UTF-8 Japanese goes into MySQL OK, comes out question marks

"Richard Pavonarius" <[email protected]>
Newsgroups gmane.comp.php.internationalization
Message-ID <[email protected]>
OK, this is officially driving me nuts.

In phpMyAdmin, I can see the Japanese text in the db. By sending the
query SET NAMES 'utf8' before inserting data, I can get my own PHP
scripts to input correctly.

However, in my PHP scripts the Japanese text is coming out of the DB
as question marks. Static Japanese text on the page is OK, so it's not
a problem with the browser font.

PHP 5.2.2, MySQL 4.13-beta-standard

php.ini:
mbstring.detect_order = auto
mbstring.encoding_translation	= On
mbstring.func_overload	= 0
mbstring.http_input = auto
mbstring.http_output  = UTF-8
mbstring.internal_encoding = UTF-8
mbstring.language = Neutral
mbstring.script_encoding  = none
mbstring.strict_detection   = Off
mbstring.substitute_character = none

/etc/my.cfg
[client]
default-character-set=utf8

[mysqld]
init-connect=SET NAMES 'utf8'
collation_server=utf8_unicode_ci
character_set_server=utf8
default-character-set=utf8

Thanks,

Rich

-- 
PHP Unicode & I18N Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.