kembreg Posted June 27, 2010 Share Posted June 27, 2010 Hi all. Have a UTF-8 Database. The data in PhpMyAdmin looks fine. Where I query the database from PHP, I do no get back proper unicode. The Website header has charset=utf-8, no problem. When I hard code some Unicode text, it appears fine on the site. -------- while( $PhraseArray= mysql_fetch_array($QueryResult) ) { $Phrase1=$PhraseArray[$SiteLanguage]; $Phrase2=$PhraseArray[$LanguageName]; //$Phrase2="Wŏ xuéxí făyŭ"; -------- i.e. 'Wŏ xuéxí făyŭ' appears fine on the site. However, when I use the value queried from the database, the unicode is garbled. Any ideas? David Quote Link to comment https://forums.phpfreaks.com/topic/205975-query-on-a-utf-8-database/ Share on other sites More sharing options...
Mchl Posted June 27, 2010 Share Posted June 27, 2010 Did you set php-database connection encoding to utf8 as well? Quote Link to comment https://forums.phpfreaks.com/topic/205975-query-on-a-utf-8-database/#findComment-1077801 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.