Page 1 of 1

HELP with Foreign Characters

Posted: Wed Jul 27, 2005 10:10 am
by dunksy
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