hi
anyone use double byte character(traditional chinese-big5) in mysql?
coz when i insert double byte character into mysql, the words become something like "&# 1234;" (i put the space coz it can't display in here)
but if i insert thru phpmyadmin, the word which store in mysql is correct.
any tricks when dealing which double byte char?
on row 1, i insert thru phpmyadmin, the word is good.
on row 2, i insert thru my own script, that's not good.
here is my code
[PHP<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body>
<?PHP
include "myconn.php";
if (isset($_POST['submit']))
{
$str = "insert into test_table (test_words) values('".$_POST['new_name']."')";
echo $str;
mysql_query($str, $myconn);
}
?>
<form action="test_insert.php" method="post">
<input type="text" name="new_name">
<input type="submit" value="submit" name="submit">
</form>
</body>
</html>
[/code]
