Re: Particular Problem Kanji
Claire Hector <[email protected]>
| Newsgroups | gmane.comp.php.internationalization |
|---|---|
| Organization | Matsushita Electric Works, Ltd. |
| Message-ID | <[email protected]> |
I will get the url and post it as all the lit. I've seen in English says exactly what you have said. As far as I know MySQL deals with Japanese using sjis & ujis character sets with ujis being equivalent to euc-jp. [If anyone knows any different please feel free to correct this!] Having read, which you also confirm that the internal encoding of php should be the same as whatever the database is I have tried setting both the server encoding (via webDav - i've never encountered this one before either) to euc-jp and php's internal encoding to euc-jp with pages encoded as shift_jis and mbstring.http_output as shift_jis..... which gives me mojibake with all the japanese text on the pages and coming from the db. I think there must be something here that I am missing or there is something with this webDav ...?! Cheers, Claire David Emery wrote: > 2004/04/07 () 09:19 Claire Hector : > > 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, > > If that's the case then surely he must have the work-around to your SJIS > mojibake problems as well, since they're more or less guaranteed to > happen with that set-up ;-) Incidentally I'd be interested in knowing > the URL he pointed to - sounds a bit fishy to me. > > > 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 > > With internal_encoding=EUC-JP your script is expecting all internal data > (including what comes from the DB) to be in EUC, so on output PHP is > probably trying to do a conversion from EUC to SJIS on text that is > actually in ujis (whatever that is?). So you get complete mojibake. I > think you'll need the data coming from your DB in the same encoding as > PHP's internal encoding. > > > > > 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 > > Dunno about webDav, but I'd guess that you'd want the ServerEncoding to > be the same as PHP's internal encoding and the DB data encoding, no? > > Basically what I've always done is have everything going to and from the > client in SJIS, and everything on the server in EUC. It's simple and > I've never had any problems with encoding. As far as I know this is more > or less the standard way to deal with Japanese in PHP. > > > ---------------------------------------------- > -- > -dave -- PHP Internationalization Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php