HELP with Foreign Characters

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
dunksy
Forum Newbie
Posts: 5
Joined: Wed Jul 27, 2005 10:09 am

HELP with Foreign Characters

Post 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
Post Reply