Claire Hector wrote: > David, > Thanks for your reply!
> I am aware that SJIS shouldn't be used for internal coding, however the config > of the server is out of my control and the person who has set it up determined > it was the best setup. It's his rice field ;-) .... i pointed out the very > clear warnings from the php site and he showed me a japanese language site > that basically justified this setup, so when he wouldn't budge I went and > changed the config settings in both php and mysql myself to see if this would > fix the problem thus I had: > Each page with shift_JIS encoding. > mbstring.language=Japanese > mbstring.internal_encoding=EUC-JP > mbsting.http_output=SJIS > MySQL table charater set ujis > and Apache using an additional module for Japanese from webDAV called > mod_encoding > with ServerEncoding set to utf-8 & DefaultClientEncoding as JA-AUTO-SJIS-MS > with this setup I had real mojibake - none of the japanese on the site > resembled kanji.... > I have not encountered the webDAV module before and am wondering if this could > be causing problems. Our network guy said that he needed to use this in order > to get the settings all working, just configuring php as he had also gave > mojibake problems!! > It is quite a frustrating problem as it only effects a few kanji and only once > they have been sent to mySQL. > Any other ideas?? > Cheers, > Claire > David Emery wrote: > > 2004/04/06 ($B2P(B) 11:58 $B$K(B Claire Hector $B$5$s$O=q$-$^$7$?(B: > > > 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 > > > > -- > > PHP Internationalization Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > -- > ------------------------------------------------ > $B>>2<EE9)3t<02q<R(B > $BIJ<AIt!!IJ<A4k2h?d?J%0%k!<%W(B > $B%/%l%"!!%X%/%?!<(B > Claire Hector > Matsushita Electric Works Ltd. > Quality Management System Group > Corporate Quality Management > E-mail: [EMAIL PROTECTED] > Notes: [EMAIL PROTECTED] > MIC:7-711-2470 [EMAIL PROTECTED](Bphone$B!K!'(B+81-6-6908-6803 > FAX:7-711-2479 [EMAIL PROTECTED](BFAX$B!K(B $B!'(B+81-6-6906-2202 > ------------------------------------------------ -- PHP Internationalization Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
