Subject | Re: [firebird-support] Re: Collation or character set with parameter |
---|---|
Author | Svein Erling Tysvær |
Post date | 2003-07-04T07:45:14Z |
>You do not have specified the collation in field definition ?I'm not certain whether the field definition explicitly contains the
>(Otherwise you do not have to specify it in ORDER BY and WHERE clauses).
collation, or whether it is only default for the database. Anyway, the field
is reported as having NO_NO collation (I am not anywhere near the database
until Monday).
>Do you have any examples which characters cause problems ?Norwegian characters are ÆØÅ. They do not cause any problem. But if a field
contains Ö (the Swedish equivalent of Ø) then the incremental searching of
IBO fails to locate records sorting below this Ö.
Set