Hmmm...

> > So IB/Fb has no case-insensitive collations by itselves?
>
> Sadly no.

Just had a try with ISO8859_1, collation DU_NL -
when I ORDER a column with these values:

And
AND
aNd

it ens up like:

aNd
And
AND


While using collation ISO8859_1 (the default), I get:

AND
And
aNd

So there does seem to be a difference there...

btw - when using the columns in a WHERE clause, they
make no difference and never return "all" rows when doing
= 'AND'


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."