Foreign Characters Break in MySQL
| From: | Ryan Park | Date: | Fri, 22 Jan 2010 01:04:27 +0000 |
| Subject: | Foreign Characters Break in MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-301331@lists.php.net to get a copy of this message | ||
Hello I'm currently trying to use PHP to insert foreign characters into one of the mysql
database tables.mysql_query() worked seamlessly, but when I check the inserted data on phpMyAdmin it
shows the foreign characters in broken letters, like this ì‹œíŒ <- jibberish...The foreign
characters show fine when I'm typing it out on my editor to code PHP, but it gets broken into
unrecognizable symbols when put into mysql database columns..
I tried to create the same thing this time through phpMyAdmin console and it worked great, the
foreign characters showed correctly as they should.The column that I'm trying to put the
foreign characters into is set as utf8_general_ci.I wish to use PHP to insert the data into the
database because I'll be inserting massive amounts of them at once, so I just can't
continue with this problem at hand.
I'll greatly appreciate any help, thank you.
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/196390709/direct/01/