Ryan Park wrote: > 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/
How about showing a little of the insert code. ie: how you are gathering the data, how you are preping the data, and the actual insert statement. -- Jim Lucas NOC Manager 541-323-9113 BendTel, Inc. http://www.bendtel.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php