Re: trouble sending japanese to mysql database!

Ah, no I hadn't (*red face*), thanks very much, works beautifully now! James "Eric Butera" <eric.butera@gmail.com> wrote in message news:6a8639eb0903051302s3b398a00m2287b15a33d3b64c@mail.gmail.com... > 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