HELP with Foreign Characters
Posted: Wed Jul 27, 2005 10:10 am
Hi there!
I have been coding in PHP/MySQL for a few years, but have never had to deal with foreign characters before, and have come accross a problem.
I am setting up a table of event types, which has an ID, an english event type, and the corresponding translation in turkish.
I am manually entering these characters into the database, using phpMyAdmin, and am coming up with this problem:
When entering "İş temasları", the database actually stores "Ýþ temaslarý" instead...
So some characters are being stored fine, but other characters aren't. If I use the ASCII codes istead of the actual character, the search system I have will not find the results, if the user enters the charecter itself instead of the ASCII code.
Another issue I have, is with some company names that contain turkish characters.
I want to have a search facility, that allows users to search for companies. The problem is that some users will not have turkish characters, and so will enter the corresponding english character instead, but I would still like the search forum to find the results.
Example: Öbur is a company, but I would like it to be found when searching for Obur as well.
Any thoughts, hints or tutorials would be much appreciated.
Many thanks,
Duncan
I have been coding in PHP/MySQL for a few years, but have never had to deal with foreign characters before, and have come accross a problem.
I am setting up a table of event types, which has an ID, an english event type, and the corresponding translation in turkish.
I am manually entering these characters into the database, using phpMyAdmin, and am coming up with this problem:
When entering "İş temasları", the database actually stores "Ýþ temaslarý" instead...
So some characters are being stored fine, but other characters aren't. If I use the ASCII codes istead of the actual character, the search system I have will not find the results, if the user enters the charecter itself instead of the ASCII code.
Another issue I have, is with some company names that contain turkish characters.
I want to have a search facility, that allows users to search for companies. The problem is that some users will not have turkish characters, and so will enter the corresponding english character instead, but I would still like the search forum to find the results.
Example: Öbur is a company, but I would like it to be found when searching for Obur as well.
Any thoughts, hints or tutorials would be much appreciated.
Many thanks,
Duncan