Re: trouble sending japanese to mysql database!

On Thu, Mar 5, 2009 at 2:06 PM, James <mlists@ichor-interactive.com> wrote: > Right, I'm having some rather strange issues between mysql and php when it > comes to inserting Japanese text. I have the table and fields set to > utf8_unicode_ci, if I use phpmyAdmin to insert japanese text through the > interface it works just fine. If I use phpmyadmin but type in the mysql > insert command in the interface it works just fine. If I use php to connect > to the database and insert the text recieved from a html form I get what > looks like the ascii codes in the record rather than the text, however if I > print that text to the browser window at the same time, the browser still > renders it as normal japanese characters. > > So: > ?????????????????? > > Is converted to : > > &#12452;&#12531;&#12472;&#12455;&#12463;&#12479;&#12540;&#12364;&#28857;&#28779;&#38918;&#24207;&#12391;&#20491;&#21029;&#12395;&#38283;&#12367;|&# > The php I'm using is: > > $link = mysql_connect($DBhost,$DBuser,$DBpass); > mysql_set_charset('utf8',$link); > $db_selected = mysql_select_db($DBName, $link); > if (!$db_selected) { die ('Database access error : ' . mysql_error());} > > $query = "INSERT INTO QuestionsJA (ID, QuestionText, > AnswerText, Correct, > Type, QGroup, Active) VALUES ('$QID','$QText', '$Ans', > '$Cor', '$Type', > '$QGroup', '$Active')"; > > mysql_query($query) or die('Error, Feedback insert into database failed') > > I can output the variables containing the text into the browser and it > displays as it should, just seems to be the communication between php and > mysql. > > Please help, this is driving me nuts. > > I've also tried adding: > > mysql_query ('SET NAMES utf8'); > mysql_query ('SET character_set_client = utf8'); > mysql_query ('SET character_set_results = utf8'); > mysql_query ('SET character_set_connection = utf8'); > > to the script but still no difference. > > Thanks > James > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Do you have a meta tag and http header stating your content is utf8? <META http-equiv="Content-Type" content="text/html; charset=UTF-8"> header('Content-Type: text/html; charset=utf-8'); -- http://www.voom.me | EFnet: #voom