Japanese and MySQL

[chemlight]

I'm having some troubles with the japanese character set and mysql.

I have a list of vendors with their languages in a table.

The language list for Japanese has been stored in Japanese. When I view the tables in phpMyAdmin, I see the proper Japanese characters. They are stored using utf8_unicode_ci. When I create a query, and try to display them on an HTML page, I only get question marks. The page is displayed using utf8. I don't know where the disconnect is, or what I am missing, but I'm guessing (I could be way off) that there is something with how the query pulls the information from the database.

What suggestions are there on getting the Japanese characters to display properly?

P.S. I'm using Firefox on a Mac OS X 10.5 system, so I have full character support for the Japanese language.

[mwasif]

Look at this thread http://bytes.com/topic/mysql/answers...l-arabic-fonts

[chemlight]

Great! Thanks. The last part of the php was what I was missing.

[mwasif]

You are welcome.

[chemlight]

Side note to anyone else who may be having issues with Japanese.

I was using AJAX to dynamically update the page. When I sent the japanese characters through AJAX and used escape(characters) it would not update properly in the databse. This was the only solution I came up with.