Subject | Case insensitive STARTING WITH |
---|---|
Author | ainpoissee |
Post date | 2008-04-18T14:06:43Z |
Hi,
In the 2.1 release notes it is mentioned that
In Firebird 1.5.x, only the ASCII-equivalent characters are uppercased
in any character set's default (binary) collation order, which is the
one that is used if no collation is specified.
Does that mean that it is now safe to implement case insensitive
STARTING WITH as "UPPER(Field) STARTING UPPER(:param)", ie there is no
need to specify collation?
TIA
ain
In the 2.1 release notes it is mentioned that
In Firebird 1.5.x, only the ASCII-equivalent characters are uppercased
in any character set's default (binary) collation order, which is the
one that is used if no collation is specified.
Does that mean that it is now safe to implement case insensitive
STARTING WITH as "UPPER(Field) STARTING UPPER(:param)", ie there is no
need to specify collation?
TIA
ain