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 (火) 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
>
> --
> PHP Internationalization Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
------------------------------------------------
松下電工株式会社
品質部 品質企画推進グループ
クレア ヘクター
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）：+81-6-6908-6803
FAX:7-711-2479 [EMAIL PROTECTED](BFAX） ：+81-6-6906-2202
------------------------------------------------
--
PHP Internationalization Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
