Welcome to WebmasterWorld Guest from 23.23.46.20

Forum Moderators: open

search turkisch İ and i, collation, would like both returned

Turkisch İ search also search I

   
10:09 pm on Mar 10, 2012 (gmt 0)



Hello,

I have stored a string in the table with the turkish character "İ"

I would like to be able to select/search "I" and also get the results for "İ" and the other way around.

I have tried playing with collation, it seems i have a few choices: utf8_turkish_ci or utf8_general_ci. But they do not make the select return results with both characters if i search any of them.

What is the best way to achieve this?
I use MySql.


Best regards,
Ugur
10:25 pm on Mar 10, 2012 (gmt 0)




sorry for the trouble.. it now seems to work with utf8_turkish_ci ? maybe my browsers cached something, or i did some wrong sql?

have a nice day
 

Featured Threads

Hot Threads This Week

Hot Threads This Month