[pgsql-jp: 38220] Re: [Pginstaller-devel] Codepage of EUC_jp is 20932

[Hiroshi Saito]

Hi ITAGAKI-san.

The part was corrected.
Anyway, Thanks.!

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "User H-saito" <h-saito ＠ pgfoundry.org>
To: <pgsql-committers ＠ postgresql.org>
Sent: Monday, March 26, 2007 11:56 AM
Subject: [COMMITTERS] pginstaller - pginst: Fixed definition of EUC_jp codepage.


> Log Message:
> -----------
> Fixed definition of EUC_jp codepage.
> This was helped by ITAGAKI Takahiro-san's report.
> 20932 should be used here instead of 51932. (MSDN might be wrong!)
> 
> #The locale was not chiefly used in Japan....
> #Therefore, it did not notice easily.:-( 
> Thanks!

----- Original Message ----- 
From: "ITAGAKI Takahiro" <itagaki.takahiro ＠ oss.ntt.co.jp>
To: <pginstaller-devel ＠ pgfoundry.org>
Cc: <pgsql-jp ＠ ml.postgresql.jp>
Sent: Monday, March 26, 2007 11:08 AM
Subject: [Pginstaller-devel] Codepage of EUC_jp is 20932


>I found a bug in the definition of EUC_jp codepage.
> 20932 should be used here instead of 51932. (MSDN might be wrong!)
> 
> If we choose EUC_jp as a encoding and 'Japanese, Japan' as a locale,
> pginstaller tries to set 'Japanese_Japan.51932' and fails.
> Then it sets 'Japanese_Japan' (without locale),
> but it means 'Japanese_Japan.932' (SJIS). 
> The mismatch of server encoding and locale encoding causes problems.
> It might be better to check the locale encoding more strictly.
> 
> setlocale(LC_COLLATE, "Japanese_Japan") -> OK (Japanese_Japan.932)
> setlocale(LC_COLLATE, "Japanese_Japan.932") -> OK
> setlocale(LC_COLLATE, "Japanese_Japan.20932") -> OK
> setlocale(LC_COLLATE, "Japanese_Japan.51932") -> ERROR
> 
> Regards,
> ---
> ITAGAKI Takahiro
> 
> _______________________________________________
> Pginstaller-devel mailing list
> Pginstaller-devel ＠ pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pginstaller-devel