Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] trouble with to_char('L')

From: Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] trouble with to_char('L')
Date: 2010-04-20 08:34:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers
Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> > 1. setlocale(LC_CTYPE, lc_monetary)
> > 2. setlocale(LC_MONETARY, lc_monetary)
> > 3. lc = localeconv()
> > 4. pg_do_encoding_conversion(lc->xxx,
> >      FROM pg_get_encoding_from_locale(lc_monetary),
> >      TO GetDatabaseEncoding())
> > 5. Revert LC_CTYPE and LC_MONETARY.

A patch attached for the above straightforwardly. Does this work?
Note that #ifdef WIN32 parts in the patch are harmless on other platforms
even if they are enabled.

> Let's work off what we have now to start with at least. Bruce, can you
> comment on that thing about the extra parameter? And UTF8?

Takahiro Itagaki
NTT Open Source Software Center

Attachment: pg_locale_20100420.patch
Description: application/octet-stream (4.3 KB)

In response to


pgsql-hackers by date

Next:From: Fujii MasaoDate: 2010-04-20 09:47:51
Subject: Re: [HACKERS] Streaming replication document improvements
Previous:From: Nikhil SontakkeDate: 2010-04-20 06:47:38
Subject: Re: row estimation off the mark when generate_series calls are involved

pgsql-general by date

Next:From: Peter BexDate: 2010-04-20 09:01:03
Subject: Re: Tuple storage overhead
Previous:From: Rene SchickbauerDate: 2010-04-20 07:10:48
Subject: Re: Virtual table with pl/perl?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group