Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-17 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > could not determine encoding for locale "Czech_Czech Republic.1250": codeset > is > "CP1250" Hm, we seem to have missed an entry for PG_WIN1250. Fixed. regards, tom lane ---(end of broadcast)

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-17 Thread Pavel Stehule
I did some test, but without success, Pavel I have win2003 Server .. with czech locales support. I:\PGSQL\BIN>initdb -D ../data -L i:\pgsql\share The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster wi

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-17 Thread Dave Page
Hiroshi Saito wrote: > Hi. > > From: "Magnus Hagander" <[EMAIL PROTECTED]> > >>> But, Please see. >>> http://winpg.jp/~saito/pg83/pg83b1-err3.txt >>> Japanese_Japan.65001 is error... >>> Japanese_Japan is true. >> >> Yes, that is expected. If you explicitly ask for the .65001 locale it >> will tr

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. From: "Magnus Hagander" <[EMAIL PROTECTED]> But, Please see. http://winpg.jp/~saito/pg83/pg83b1-err3.txt Japanese_Japan.65001 is error... Japanese_Japan is true. Yes, that is expected. If you explicitly ask for the .65001 locale it will try the one that doesn't have the proper NLS files,

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. From: "Pavel Stehule" <[EMAIL PROTECTED]> > I can test it with czech locale. Can I download binaries anywhere? http://winpg.jp/~saito/pg83/postgresql-8.3beta-cvs.tgz It is a thing after regression test.(MinGW+gcc) I have problem, there isn't libintl-2.dll Ooops, sorry, it is full-build.

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Dave Page wrote: >> SJIS wasn't ever supported as a server encoding >> (http://www.postgresql.org/docs/8.2/interactive/multibyte.html). The >> fact that initdb continues if you use Japanese_Japan.932 is an >> inconsistency I reported previously but has

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Pavel Stehule
2007/10/16, Hiroshi Saito <[EMAIL PROTECTED]>: > Hi. > > > I can test it with czech locale. Can I download binaries anywhere? > http://winpg.jp/~saito/pg83/postgresql-8.3beta-cvs.tgz > It is a thing after regression test.(MinGW+gcc) > I have problem, there isn't libintl-2.dll Pavel -

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Dave Page
Magnus Hagander wrote: > Dave Page wrote: >> Magnus Hagander wrote: >>> Not so. The locale is Japanese_Japan, really. That's the only part >>> that's relevant for UTF16 encodings, which is what we use to do UTF8. We >>> specifically *don't* try to use Japanese_Japan.65001. >> Thats not what I mean.

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Dave Page
Hiroshi Saito wrote: > Hi. > > From: "Dave Page" <[EMAIL PROTECTED]> >>> Yes, Please see, >>> http://winpg.jp/~saito/pg83/pg83b1-err2.txt >>> Is that initdb is successful a problem as for this? >> >> Oh, sorry - misread that. I chatted with Magnus about that. It is >> correct, but misleading. pg_c

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Dave Page wrote: > Magnus Hagander wrote: >> Not so. The locale is Japanese_Japan, really. That's the only part >> that's relevant for UTF16 encodings, which is what we use to do UTF8. We >> specifically *don't* try to use Japanese_Japan.65001. > > Thats not what I mean. From a *usability* perspec

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
But, Please see. http://winpg.jp/~saito/pg83/pg83b1-err3.txt Japanese_Japan.65001 is error... Japanese_Japan is true. However, The test of this state is continued. But but but, Sorry, I face to a bed... Regards, Hiroshi Saito ---(end of broadcast)---

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Hiroshi Saito wrote: > Hi. > > From: "Dave Page" <[EMAIL PROTECTED]> >>> Yes, Please see, >>> http://winpg.jp/~saito/pg83/pg83b1-err2.txt >>> Is that initdb is successful a problem as for this? >> >> Oh, sorry - misread that. I chatted with Magnus about that. It is >> correct, but misleading. pg_c

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Dave Page
Magnus Hagander wrote: > Not so. The locale is Japanese_Japan, really. That's the only part > that's relevant for UTF16 encodings, which is what we use to do UTF8. We > specifically *don't* try to use Japanese_Japan.65001. Thats not what I mean. From a *usability* perspective, Hiroshi should see J

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. From: "Dave Page" <[EMAIL PROTECTED]> Yes, Please see, http://winpg.jp/~saito/pg83/pg83b1-err2.txt Is that initdb is successful a problem as for this? Oh, sorry - misread that. I chatted with Magnus about that. It is correct, but misleading. pg_control will say Japanese_Japan.932 as well i

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Dave Page wrote: > Hiroshi Saito wrote: >> From: "Dave Page" <[EMAIL PROTECTED]> >> >>> Hiroshi Saito wrote: Hi. Second, it is big problem http://winpg.jp/~saito/pg83/pg83b1-err2.txt It is text serch config error. However, It passes initdb.(locale=Japanese_Japan.93

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Dave Page wrote: > Hiroshi Saito wrote: >> Hi. >> >> Second, it is big problem >> http://winpg.jp/~saito/pg83/pg83b1-err2.txt >> It is text serch config error. >> However, It passes initdb.(locale=Japanese_Japan.932 ... This is >> ShiftJIS locale) >> >> And a test continues > > The changes

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Dave Page
Hiroshi Saito wrote: > From: "Dave Page" <[EMAIL PROTECTED]> > >> Hiroshi Saito wrote: >>> Hi. >>> >>> Second, it is big problem >>> http://winpg.jp/~saito/pg83/pg83b1-err2.txt >>> It is text serch config error. >>> However, It passes initdb.(locale=Japanese_Japan.932 ... This is >>> ShiftJIS

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
From: "Dave Page" <[EMAIL PROTECTED]> Hiroshi Saito wrote: Hi. Second, it is big problem http://winpg.jp/~saito/pg83/pg83b1-err2.txt It is text serch config error. However, It passes initdb.(locale=Japanese_Japan.932 ... This is ShiftJIS locale) And a test continues The changes that

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Dave Page
Hiroshi Saito wrote: > Hi. > > Second, it is big problem > http://winpg.jp/~saito/pg83/pg83b1-err2.txt > It is text serch config error. > However, It passes initdb.(locale=Japanese_Japan.932 ... This is > ShiftJIS locale) > > And a test continues The changes that were made were only to r

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. Hiroshi Saito wrote: Hi. Second, it is big problem http://winpg.jp/~saito/pg83/pg83b1-err2.txt It is text serch config error. However, It passes initdb.(locale=Japanese_Japan.932 ... This is ShiftJIS locale) And a test continues What text search config would you expect? This p

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Hiroshi Saito wrote: > Hi. > > Second, it is big problem > http://winpg.jp/~saito/pg83/pg83b1-err2.txt > It is text serch config error. > However, It passes initdb.(locale=Japanese_Japan.932 ... This is > ShiftJIS locale) > > And a test continues What text search config would you expect?

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Hiroshi Saito wrote: > Hi. > >> Um, It seems that it only passed the strict check of chklocale.c. >> Probably, It may enable mistaken selection...However, I will clarify a >> problem by the test. > > First, it is one problem > http://winpg.jp/~saito/pg83/pg83b1-err.txt > > And a test continu

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. Second, it is big problem http://winpg.jp/~saito/pg83/pg83b1-err2.txt It is text serch config error. However, It passes initdb.(locale=Japanese_Japan.932 ... This is ShiftJIS locale) And a test continues Regards, Hiroshi Saito ---(end of broadcast)-

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. Um, It seems that it only passed the strict check of chklocale.c. Probably, It may enable mistaken selection...However, I will clarify a problem by the test. First, it is one problem http://winpg.jp/~saito/pg83/pg83b1-err.txt And a test continues ---(end o

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. I can test it with czech locale. Can I download binaries anywhere? http://winpg.jp/~saito/pg83/postgresql-8.3beta-cvs.tgz It is a thing after regression test.(MinGW+gcc) Regards, Hiroshi Saito ---(end of broadcast)--- TIP 2: Don't 'kill -9'

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Pavel Stehule
2007/10/16, Magnus Hagander <[EMAIL PROTECTED]>: > Tom Lane wrote: > > [EMAIL PROTECTED] (Magnus Hagander) writes: > >> Re-allow UTF8 encodings on win32. Since UTF8 is converted to > >> UTF16 before being used, all (valid) locales will work for this. > > > > So where do we stand on the Windows loca

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Hiroshi Saito
Hi. Um, It seems that it only passed the strict check of chklocale.c. Probably, It may enable mistaken selection...However, I will clarify a problem by the test. Regards, Hiroshi Saito From: "Magnus Hagander" <[EMAIL PROTECTED]> Tom Lane wrote: [EMAIL PROTECTED] (Magnus Hagander) writes:

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Magnus Hagander
Tom Lane wrote: > [EMAIL PROTECTED] (Magnus Hagander) writes: >> Re-allow UTF8 encodings on win32. Since UTF8 is converted to >> UTF16 before being used, all (valid) locales will work for this. > > So where do we stand on the Windows locale/encoding business --- are > we happy with the behavior n

Re: [HACKERS] [COMMITTERS] pgsql: Re-allow UTF8 encodings on win32.

2007-10-16 Thread Tom Lane
[EMAIL PROTECTED] (Magnus Hagander) writes: > Re-allow UTF8 encodings on win32. Since UTF8 is converted to > UTF16 before being used, all (valid) locales will work for this. So where do we stand on the Windows locale/encoding business --- are we happy with the behavior now, or does it still need