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
Special characters Search Problem
Moderator: General Moderators
Re: Special characters Search Problem
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?
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
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
(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
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?
What kind of server are you running, Wamp / Lamp?