Am 6 Jun 2005 um 10:30 hat Petr Hartman geschrieben:

> You must also specify COLLATE (either when you are creating table or when you are searching data).
>
> 1. create table CUSTOMER (NAME VARCHAR(30) COLLATE DE_DE)
> select * from customer where upper(name) like :search
>
> 2. create table CUSTOMER (NAME VARCHAR(30))
> select * from customer where upper(name COLLATE DE_DE) like :search
>
> Petr

Petr,
thanks for your reply. Indeed the collation sequence solved the
problem with the like operator. I just dropped the 'collate de_de' from
all my domains some weeks ago as the sorting was not as I need
(NONE is the one I use, so pure binary sorting).
So I decided to use the syntax from your example 2.
My first tests look pretty good.

Regards
Gunther





___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de