Hii there, I have a table containing cities of the world. Now I am running into problems because people are starting to complain that some mayor cities are not in the db like Tokyo. After checking my table I discovered that there lots of cities are written with some non latin characters.
Tokyo is written like this: Tðkyð Should, and if how, I convert this characters into latin ones. And what happens if somebody from Japan with a different keyboard tries to find Tokyo? Anyway what type of character is this 'ð' anyway? It does not look Japanese to me :-) I also heard, that it is possible to compile mysql with only a latin char set. Would this be helpful for me? Thank you for any help on that, Andy query ---------------------------------------------------- http://www.globosapiens.net Global Travellers Network! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php