Special Character search lik

[preetinder dhaliwal]

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

[KalpanaPai]

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