Re: =?ISO-8859-1?Q?Special_Character_search__lik?= =?ISO-8859-1?Q?_e__=E9_in_the_informix_database?=

Any luck !!!!!!! kalpanapai@hotmail.com (KalpanaPai) wrote in message news:<8b77f6f5.0308202106.4538f987@posting.google.com>... > 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