Commented by: @WarmBooter

The result of lower depends on the charset you are using. What charset you have tried?

Commented by: Sean Leyne (seanleyne)

What is the result if you reverse the order of the operations to SUBSTR, LOWER?

Commented by: christophe derenne (cdr60530)

Hi,

select substr(lower('JoËl'),3,3) from rdb$database; is working but this syntax is not corresponding to what I want to do in my stored procedure.

Commented by: Sean Leyne (seanleyne)

1- This points out that the problem is not with LOWER() but with SUBSTR(), so the case title/subject should be changed.

2- Although this may not be how you SP is coded, changing the sequence of operation at least provides a workaround to the problem.

Commented by: christophe derenne (cdr60530)

At first, the title was about the lower fonction but Sean Leyne ask me to change the title beacause if substr is using after lower, it give the right result, so, substr that has probably a bug inside and not the lower function.

Commented by: @asfernandes

"substr" is legacy UDF function which should not be used. Use SUBSTRING(x from y to z) which surely will work better with charsets and collations.

Commented by: christophe derenne (cdr60530)

Hi, I'm surprised, because I love Firebird, this is a greate DBRM with very good performance for free. I'm using it since 15 years (before Firebird, I was using Interbase).
So I thank everybody who had work on this project.

But what ?
Ok you gave me a solution : thank you for that.
But Pavel Cisar closed the subject and indicate that it won't be fix ?

You are saying that substr function is buggy , will continue to exist wand will never be fixed !

I can't believe that, you should say, will be fixed later or will be deprecated : i would understand