Page 4 of 4

Re: Special characters Search Problem

Posted: Tue Apr 07, 2009 7:19 am
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

Re: Special characters Search Problem

Posted: Tue Apr 07, 2009 7:58 am
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?

Re: Special characters Search Problem

Posted: Tue Apr 07, 2009 8:16 am
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

Re: Special characters Search Problem

Posted: Tue Apr 07, 2009 8:30 am
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?