Re: Special Character search lik

#1

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:

Quote:

Any luck !!!!!!!

kalpanapai (AT) hotmail (DOT) com (KalpanaPai) wrote in message news:<8b77f6f5.0308202106.4538f987 (AT) posting (DOT) 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

#2

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 (AT) dhl (DOT) com> wrote

Quote:

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 (AT) hotmail (DOT) com (KalpanaPai) wrote in message news:<8b77f6f5.0308202106.4538f987 (AT) posting (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Special Character search lik

comp.databases.informix comp.databases.informix

Re: Special Character search lik - 08-25-2003 , 08:02 PM

Re: Special Character search lik - 08-26-2003 , 11:17 PM