| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|search turkisch İ and i, collation, would like both returned|
Turkisch İ search also search I
| 10:09 pm on Mar 10, 2012 (gmt 0)|
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.
| 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
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved