How do I get mySQL and PHP to accept Japanese characters?

  • Thread starter Thread starter Vexeq
  • Start date Start date
V

Vexeq

Guest
I've been searching for the last couple of hours, trying to figure this out, and nothing I've found seems to be working, so could anyone help? I'm trying to send Japanese sentences from HTML using PHP into my mySQL database, and when I view them from phpMyAdmin, they look like... this: "&#12375" instead of actual characters. I've tried encoding ALL the files I'm using, including the tables in the database, to UTF-8 and still the Japanese text I send out ends up looking garbled (the English translation accompanying it is fine, of course). I'm not getting question mark characters, though, unless I save the PHP file in notepad as UTF-8 before stripping the .txt extension and just leaving it as .php... I get some really weird and messed up symbols then.
If it's worth noting, I can add the Japanese characters in phpMyAdmin, manually, and they come out just fine. MySQL is version 5.1.30, phpMyAdmin is version 3.1.1, and PHP is 5.2.8, too. My tables are set to "utf8_general_ci", though I've tried anything that has Japanese to do with it and they don't work, either. I'm pretty new to all this and am not sure what I should do about it? Please help?
 
Back
Top