Re: [tlug] OT-Japanese in PHP

[Mark Sargent <powderkeg@example.com>]

Erin D. Hughes via info@example.com wrote:

> David E wrote:
>
>> From: Mark Sargent <powderkeg@example.com> on Date: Wed, 25 May 
>> 2005 17:31:49 +0900
>>
>>
>>> Erin D. Hughes via info@example.com wrote:
>>>
>>>
>>>> Mark Sargent wrote:
>>>>
>>>>
>>>>> Hi All,
>>>>> output_handler = mb_output_handler
>>>>> mbstring.language = Japanese
>>>>> mbstring.internal_encoding = UTF-8
>>>>> mbstring.http_input = auto
>>>>> mbstring.http_output = SJIS
>>>>> mbstring.encoding_translation = On
>>>>> mbstring.detect_order = auto
>>>>> mbstring.substitute_character = none
>>>>> mbstring.internal_encoding = EUC-JP
>>>>>
>>>>> Now, I think I still haven't got the page that requires J, 
>>>>> displayed right, yet. Full code is below. Can anyone see any 
>>>>> mistakes..? Cheers.
>>>>
>>
>>
>> You haven't given any details on what seems wrong with the output.
>> This is kind of obvious, but have you made sure the text in the
>> database is in the sme encoding as you have mbstring.internal_encoding
>> set to? (You have it set twice, to different values in your config
>> above - I assume the last one set gets used, but safer to just make up
>> your mind, don't you think?)
>>
>> Dave
>>
> Dave I agree that is another valid point.
>
> I think he should first rule out the other problems though
>
> A. Make a test page with some Japanese text in HTML and test. IS that 
> OK? If yes go to B
>
> B. Make a test page in PHP with the same text and test. IS that OK? If 
> yes go to C.
>
> C. Make a test PHP page that pulls data from the DB. And in 3 separate 
> lines with each line (data in the db encoded differently IE UTF-8, 
> Shift-jis and EUC) and see what comes out right.
>
> Also it is important to check the co-location in your DB if your using 
> MYSQL 4.XXXXXXXXXX there are very specific settings that I have had a 
> lot of trouble with my self in the past..... But that is another issue 
> I am sure.
>
> E./
>
>
Test A:
Hondaは、スポーティで安心感のある走りに加え、上質な内外装、高い安全性能 
により好評を得ているアコードシリーズ（アコード／アコードワゴン）を改良 
し、本日より全国のホンダクリオ店から発売する。

　アコードでは、充実した装備の24TLにエアロパーツや17インチアルミホイー 
ル、スポーツサスペンションを装備した「スポーツパッケージ」を、アコードワ 
ゴンでは、2.0Lエンジンを搭載したベーシックなタイプ「20A」を、それぞれ新 
たに設定。お客様の幅広い要望に応えられるタイプ設定とした。
　また今回、アコード20A、20ELのFF車と、アコードワゴン20A、24EのFF車は 
「平成17年排出ガス基準75％低減レベル（★★★★低排出ガス車）」認定を新たに取 
得し、高い環境性能を実現するとともにグリーン税制の適用対象を拡大した。


Result Test A(Comes out as coded in UTF-8)
Honda縺ｯ縲√せ繝昴・繝・ぅ縺ｧ螳牙ｿ・─縺ｮ縺ゅｋ襍ｰ繧翫↓蜉 縺医∽ｸ願ｳｪ縺ｪ 
蜀・､冶｣・・ｫ倥＞螳牙・諤ｧ閭ｽ縺ｫ繧医ｊ螂ｽ隧輔ｒ蠕励※縺・ｋ繧｢繧ｳ繝ｼ繝峨 
す繝ｪ繝ｼ繧ｺ・医い繧ｳ繝ｼ繝会ｼ上い繧ｳ繝ｼ繝峨Ρ繧ｴ繝ｳ・峨ｒ謾ｹ濶ｯ縺励∵悽譌･ 
繧医ｊ蜈ｨ蝗ｽ縺ｮ繝帙Φ繝繧ｯ繝ｪ繧ｪ蠎励°繧臥匱螢ｲ縺吶ｋ縲・縲繧｢繧ｳ繝ｼ繝峨〒 
縺ｯ縲∝・螳溘＠縺溯｣・ｙ縺ｮ24TL縺ｫ繧ｨ繧｢繝ｭ繝代・繝・ｄ17繧､繝ｳ繝√い繝ｫ繝 
溘・繧､繝ｼ繝ｫ縲√せ繝昴・繝・し繧ｹ繝壹Φ繧ｷ繝ｧ繝ｳ繧定｣・ｙ縺励◆縲後せ繝 
昴・繝・ヱ繝・こ繝ｼ繧ｸ縲阪ｒ縲√い繧ｳ繝ｼ繝峨Ρ繧ｴ繝ｳ縺ｧ縺ｯ縲・.0L繧ｨ繝ｳ繧ｸ 
繝ｳ繧呈政霈峨＠縺溘・繝ｼ繧ｷ繝・け縺ｪ繧ｿ繧､繝励・0A縲阪ｒ縲√◎繧後◇繧梧眠 
縺溘↓險ｭ螳壹ゅ♀螳｢讒倥・蟷・ｺ・＞隕∵悍縺ｫ蠢懊∴繧峨ｌ繧九ち繧､繝苓ｨｭ螳壹→ 
縺励◆縲・縲縺ｾ縺滉ｻ雁屓縲√い繧ｳ繝ｼ繝・0A縲・0EL縺ｮFF霆翫→縲√い繧ｳ繝ｼ繝峨 
Ρ繧ｴ繝ｳ20A縲・4E縺ｮFF霆翫・縲悟ｹｳ謌・7蟷ｴ謗貞・繧ｬ繧ｹ蝓ｺ貅・5・・ｽ取ｸ帙Ξ 
繝吶Ν・遺・笘・・笘・ｽ取賜蜃ｺ繧ｬ繧ｹ霆奇ｼ峨崎ｪ榊ｮ壹ｒ譁ｰ縺溘↓蜿門ｾ励＠ 
縲・ｫ倥＞迺ｰ蠅・ｧ閭ｽ繧貞ｮ溽樟縺吶ｋ縺ｨ縺ｨ繧ゅ↓繧ｰ繝ｪ繝ｼ繝ｳ遞主宛縺ｮ驕ｩ 
逕ｨ蟇ｾ雎｡繧呈僑螟ｧ縺励◆縲・

Now, I realized, after an email from Dave E that I had 
internal.encoding as UTF-8 although the database encoding is SJIS. I 
just wasn't fully understanding what all the settings were doing. I've 
now changed the internal to SJIS, double checked that the page is set 
for SJIS also, but, the page only displays if I either change it in the 
browser to UTF-8 or set the page to that(Test A page, that is). I've 
added below my settings. The original page, that displays the database 
content, which is set to Shift_JIS also still doesn't display, at all. 
Thoughts..? Cheers.

EDIT: I went and copied the data from the database into the Test A page 
and it also would only display correctly if I set it to UTF-8 in the 
browser. So, this narrows it down to, that the code is being coded to 
UTF-8. I don't understand this, as I've set all settings to SJIS. 
Obviously I'm missing something very fundamental, which I'm sure will 
pointed out to me, real quick. Cheers, again.

Mark Sargent.


mbstring.detect_order auto

mbstring.encoding_translation On

mbstring.func_overload 0

mbstring.http_input Auto

mbstring.http_output SJIS

mbstring.internal_encoding SJIS

mbstring.language Japanese

mbstring.substitute_character no value