Re: Special Character search lik

How did u insert mycaf' in database ?? Use same client settings which u used for insert. Hope this helps. ( Else post ur settings or method to insert into DB these values ) Rgds Preetinder KalpanaPai wrote: >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 >> >> sending to informix-list