=?ISO-8859-1?Q?Special_Character_search__lik?= =?ISO-8859-1?Q?e__=E9_in_the_informix_database?=

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