Re: Particular Problem Kanji

From: Date: Tue, 06 Apr 2004 23:56:04 +0000
Subject: Re: Particular Problem Kanji
References: 1  Groups: php.i18n 
Request: Send a blank email to php-i18n+get-686@lists.php.net to get a copy of this message
2004/04/06 (火) 11:58 に Claire Hector さんは書きました: > Hello! > I have a question regarding some particular Japanese words. > > I have a MySQL database and have set the character set for selected > tables to sjis (I have also tried this with ujis and various php > settings) > > php.ini settings for mbstring are as follows: > > mbstring.language=Japanese > mbstring.internal_encoding=SJIS You shouldn't use SJIS for internal encoding or in your DB, or inside your PHP. It's evil and will cause exactly the type of problems you're having. I think the mbstring docs explain this. Setting mbstring.internal_encoding to EUC would be better. UTF is good too, but I don't think it's supported by MySQL. There should be an mbstring.http_output setting as well, which you probably want to set to SJIS. > mbstring.http_input=auto > mbstring.http_input=UTF-8 > mbstring.encoding_translation=on > mbstring.detect_order=auto > mbstring.substitute_character=none > > [the server was configured by our network person so i am not 100% sure > of the reasoning behind these particular settings.] > > The server is Apache using an additional module for Japanese from webDAV > called mod_encoding > with ServerEncoding set to utf-8 & DefaultClientEncoding as > JA-AUTO-SJIS-MS > > Each page is encoded as shift_jis. (i have also played around with these > and the get the same problems if this is changes to utf-8 or euc-jp) > > Generally, the html pages display Japanese without problem, however > there are a couple of particular kanji that do not display properly. > When entered into a html form they look fine, when the query the data is > used for is echoed back to the screen all is fine, but once they are > actually entered into the MySQL database they change. > > Examples of problem kanji... > yo-so-ku -> when this is stored in the database it changes to the kanji > for egg and a small katakana i... > yo-so-u -> when this is stored in the database it changes to the kanji > for egg and a small z... > also > ko-u-chi-ku > ju-u-bu-n > hyo-u-to > hyo-u-sho-u > > Can this be changed by altering the encoding scheme chosen or are these > particular problem kanji and should just be avoided? > > > I would really appreciate your expertise in helping me make sense of > this. > Thanks, > Claire -- -dave

« previous php.i18n (#686) next »