Subject Re: [firebird-support] ORDER BY and TERM CHAR
Author Helen Borrie
At 10:44 PM 7/09/2003 -0500, you wrote:
>This SQL statement (fragment only shown)
> + ' ORDER BY ' + fld;
>behaves different depending on whether there is a term char.
>If no term char (';') it will order without regard to case.
>if, however, the term char (';') is added, the ordering
>is case sensitive.
>Can I count on this behavior?

Definitely not! it's certainly not related to any "engine feature" or API
function. If you observe this behaviour consistently then it will have
something to do with the way your client software parses SQL.

>Is this the way it is intended to work?

No. The only way to get case-insensitive ordering via SQL is to have the
sorting dependent on an index that *provides* a case-insensitive ordering
by one means or another. It has nothing to do with whether the statement
does or doesn't have a terminator character.