Re: Particular Problem Kanji

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   $B30@~!J(Bphone$B!K!'(B+81-6-6908-6803
> FAX:7-711-2479   $B30@~!J(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