| 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: | 20100420173406.93AF.52131E4D@oss.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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?
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
| Attachment | Content-Type | Size |
|---|---|---|
| pg_locale_20100420.patch | application/octet-stream | 4.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Bex | 2010-04-20 09:01:03 | Re: Tuple storage overhead |
| Previous Message | Rene Schickbauer | 2010-04-20 07:10:48 | Re: Virtual table with pl/perl? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2010-04-20 09:47:51 | Re: [HACKERS] Streaming replication document improvements |
| Previous Message | Nikhil Sontakke | 2010-04-20 06:47:38 | Re: row estimation off the mark when generate_series calls are involved |