Re: Solve a problem of LC_TIME of windows.

Hi.

Thanks all.!!!!

I tried CVS-HEAD now.

================================================
HIROSHI=# select to_char(now(),'TMDay');
to_char
----------
Saturday
(1 行)

HIROSHI=# set LC_MESSAGES=Ja;
SET
HIROSHI=# select to_char(now(),'TMDay');
to_char
----------
Saturday
(1 行)
================================================

Umm, It does not look at a comfortable result.:-(
I will check it on tomorrow night. sorry busy now..

Regards,
Hiroshi Saito

----- Original Message -----
From: "Magnus Hagander" <magnus(at)hagander(dot)net>

> ITAGAKI Takahiro wrote:
>> Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> wrote:
>>
>>> Seems LC_CTYPE and LC_TIME should be convertible even though we use
>>> wcsftime (which internally calls strftime?).
>>
>> Ok, wcsftime() requries both LC_TIME and LC_CTYPE are the same setting
>> (at least encoding) on Windows.
>>
>> The attached patch is an updated version to fix cache_locale_time().
>> Now it sets LC_TIME and LC_CTYPE to the specified locale and restore
>> them at end of the function. I tested the patch on Windows XP Japanese
>> Edition (SJIS) with UTF-8 and EUCJP databases, and worked expectedly.
>>
>> "#ifdef WIN32" codes seems to be ugly in the patch,
>> but I have no other idea...
>
> I have applied this version of the patch (with only a minor further
> addition to the comment).
>
> Thank you all for your work and patience in getting this fixed! Let's
> hope it stays fixed :-)
>
> //Magnus
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers