Forgot to reply all.
You can see that it's in the middle of the sql statement.
It looks fine here but some how it breaks during the query.
<?php
mysql_connect("localhost", "adminID", "password") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("databasename") or die(mysql_error());
echo "Connected to Database<br />";
$sql = "INSERT INTO xe_modules (module_srl, module, module_category_srl,
layout_srl, menu_srl, site_srl, mid, skin, browser_title, description,
is_default, content, open_rss, header_text, footer_text, regdate) VALUES
('135', 'bodex', '0', '53', '0', '0', 'free', 'xe_default', '자유게시판
', '', 'N', '', 'Y', '', '', UNIX_TIMESTAMP());";
mysql_query($sql) or die(mysql_error());
mysql_close();
?>
On 1/21/2010 5:19 PM, Jim Lucas wrote:
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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
