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-19 01:59:42
Message-ID:
20100419105942.A6B4.52131E4D@oss.ntt.co.jp (view raw or flat )
Thread:
2009-04-20 21:00:07 from Mikko <mhannesy(at)gmail(dot)com>
2009-04-21 10:36:44 from "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
2009-04-21 13:58:21 from Mikko <mhannesy(at)gmail(dot)com>
2009-04-21 17:13:38 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-04-21 20:32:18 from Mikko <mhannesy(at)gmail(dot)com>
2009-04-21 23:13:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-04-22 17:06:24 from Mikko <mhannesy(at)gmail(dot)com>
2009-04-22 17:58:48 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-04-22 18:35:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-22 21:35:28 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2009-05-29 18:16:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-02 03:22:13 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2009-06-03 18:06:00 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-03 23:41:41 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-02-25 23:21:58 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-25 23:32:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-25 23:33:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-25 23:46:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-26 00:16:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-26 00:44:37 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-02-26 00:52:48 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-26 23:06:31 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-02-27 21:42:34 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-28 04:28:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-28 15:13:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-03-01 11:00:15 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-03-02 03:36:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-03-02 14:40:46 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-03-02 18:14:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-03-12 06:52:07 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-03-12 17:13:48 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-03-18 03:34:20 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-03-22 20:14:53 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-16 10:52:27 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-04-19 01:59:42 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-04-19 12:02:32 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-04-20 08:34:09 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-04-20 13:23:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-20 14:28:23 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-04-21 01:50:26 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-04-22 02:00:50 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-04-24 23:03:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-26 00:19:49 from Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
2010-04-26 13:32:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-20 13:38:24 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-04-20 13:10:18 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-general pgsql-hackers
Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> But I'm unsure how that would work. We're talking about the output of
> localeconv(), right? I don't see a version of localeconv() that does
> wide chars anywhere. (You can't just set LC_CTYPE and use the regular
> function - Windows has a separate set of functions for dealing with
> UTF16).
Yeah, msvcrt doesn't have wlocaleconv :-( . Since localeconv() returns
characters in the encoding specified in LC_TYPE, we need to hande the
issue with codes something like:
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.
Another idea is to use GetLocaleInfoW() [1], that is win32 native locale
functions, instead of the libc one. It returns locale characters in wide
chars, so we can safely convert them as UTF16->UTF8->db. But it requires
an additional branch in our locale codes only for Windows.
[1] http://msdn.microsoft.com/en-us/library/dd318101
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-04-19 02:04:50Subject : Re: master in standby mode croaksPrevious :From : Fujii MasaoDate : 2010-04-19 01:58:05Subject : Re: master in standby mode croaks
pgsql-general by date
Next :From: Đỗ Ngọc Trí CườngDate: 2010-04-19 02:26:53Subject : Help with tracking!Previous :From : Vick KheraDate : 2010-04-19 01:27:26Subject : Re: partitioned lookup table?
