Re: Special Character search lik

The data will be keyworded from the client through our application, and also i can insert the data with given settings, i just copied the symbol and inserted with insert statement . We are having a problem when the client searh for the word or statement from the application which has this letter. We have many clients , only few of them enter such characters . hanks heaps !!!!!!!! Cheers kalpana preetinder dhaliwal <preetinder.dhaliwal@dhl.com> wrote in message news:<biedsf$7n3$1@terabinaries.xmission.com>... > 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