homepage Welcome to WebmasterWorld Guest from 54.205.119.163
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
search turkisch İ and i, collation, would like both returned
Turkisch İ search also search I
ikbenhet4




msg:4427644
 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

 

ikbenhet4




msg:4427647
 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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved