Hi

Is there anythig needs to be set in informix for searching keywords
like café .

If i give sql as
select * from test where name matches '*mycafé*'
or select * from test where name matches '*café*'
it does not work

but it works with the foll
select * from test where name matches '* café*'
select * from test where name matches '*my café'

We have setting on the server as follows

LC_COLLATE=en_US.ISO8859-1
LC_CTYPE=en_US.ISO8859-1
LC_MESSAGES=C
LC_MONETARY=en_US.ISO8859-1
LC_NUMERIC=en_US.ISO8859-1
LC_TIME=en_US.ISO8859-1

As i never faced such problems with Oracle and i believe it works in
other dbs like Sqlserver, DB2 , Dbaccess etc

Any clues appreciated

Thanks & Regards
Kalpana

Any luck !!!!!!!




kalpanapai (AT) hotmail (DOT) com (KalpanaPai) wrote in message news:<8b77f6f5.0308202106.4538f987 (AT) posting (DOT) google.com>...