Special characters Search Problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

HarPaddy
Forum Commoner
Posts: 40
Joined: Tue Feb 03, 2009 12:54 am

Re: Special characters Search Problem

Post by HarPaddy »

This is not the correct one..

I am getting the result as

(c06e67) 0, (e06e67) 0, (c06e67) 0, (e06e67) 0, (414e47) 0, (616e67) 0, (4e4745) 1, (6e6765) 1,


We are getting empty results for utf8encoding of 'Àngel','àngel' and also ansi encoding of 'Àngel','àngel' and also 'Angel','angel'.

This is not the correct one.
We need to get the records(result 1) when the search word is like 'Àngel', 'àngel', 'Angel' and 'angel'. Its my exact search module.


Can u please give suggestions to get this?

Thanks,
HarPaddy
User avatar
Apollo
Forum Regular
Posts: 794
Joined: Wed Apr 30, 2008 2:34 am

Re: Special characters Search Problem

Post by Apollo »

Something is really messed up on your system :( Somehow it refuses unicode collations, and the ansi ci collations aren't working as expected.

Does it make a difference when you:
- change 'latin1_german1_ci' into 'latin1_swedish_ci'
- remove the COLLATE parameter, i.e. just SET NAMES 'latin1'
- remove the SET NAMES query entirely

Can you run that last test again with these 3 changes?
HarPaddy
Forum Commoner
Posts: 40
Joined: Tue Feb 03, 2009 12:54 am

Re: Special characters Search Problem

Post by HarPaddy »

I have executed the 3 Steps, and i got same output as like this

(c06e67) 0, (e06e67) 0, (c06e67) 0, (e06e67) 0, (414e47) 0, (616e67) 0, (4e4745) 1, (6e6765) 1,

(c06e67) 0, (e06e67) 0, (c06e67) 0, (e06e67) 0, (414e47) 0, (616e67) 0, (4e4745) 1, (6e6765) 1,

(c06e67) 0, (e06e67) 0, (c06e67) 0, (e06e67) 0, (414e47) 0, (616e67) 0, (4e4745) 1, (6e6765) 1,

What we should do for supporting collations ansi ci and unicode

Thanks,
HarPaddy
User avatar
Apollo
Forum Regular
Posts: 794
Joined: Wed Apr 30, 2008 2:34 am

Re: Special characters Search Problem

Post by Apollo »

Can you check your server's locale / SQL settings? And perhaps upgrade your SQL server? Does it list any character sets there, and specify any defaults?

What kind of server are you running, Wamp / Lamp?
Post Reply