Re: [GENERAL] Question for Postgres 8.3

2008-02-05 Thread Gregory Stark
"rihad" <[EMAIL PROTECTED]> writes: >> If you want to support multiple encodings, the only safe locale choice >> is (and always has been) C. > > I should be ashamed for asking this, but would someone care to tell me how > encoding differs from locale? One you missed is a character set, which is j

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread rihad
If you want to support multiple encodings, the only safe locale choice is (and always has been) C. I should be ashamed for asking this, but would someone care to tell me how encoding differs from locale? My postgresql FreeBSD rcNG script reads: postgresql_initdb_flags=${postgresql_initdb_fla

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Clemens Schwaighofer
On 02/05/2008 03:38 PM, Hiroshi Saito wrote: > Hi. > > This reply is very glad for me!:-) > However, There is still a locale problem. If I use an EUC database on an UTF8 system? Well I will try out and see if it breaks everything. > Anyway, thanks > > Regards, > Hiroshi Saito > > - Ori

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Hiroshi Saito
Hi. This reply is very glad for me!:-) However, There is still a locale problem. Anyway, thanks Regards, Hiroshi Saito - Original Message - From: "Clemens Schwaighofer" <[EMAIL PROTECTED]> I'm surprised your clients haven't been screaming about bogus sorting and upper/lowercasin

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Hiroshi Saito
I'm surprised your clients haven't been screaming about bogus sorting and upper/lowercasing behavior. Umm, This is a mere information. (Since you dislike, this may be a noise.?) As for upper/lower. It does not change, even if uses which locale in us Japanese. (there is nothing with the alphabe

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread David Wall
If you want to support multiple encodings, the only safe locale choice is (and always has been) C. If you doubt this, troll the archives for awhile --- for example, searching for locale+encoding in pgsql-bugs should provide plenty of amusing reading matter. This is most interesting. I think

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Hiroshi Saito
Hi. - Original Message - From: "Clemens Schwaighofer" <[EMAIL PROTECTED]> hi, on the page: in point E.1.2.3: * Disallow database encodings that are inconsistent with the server's locale setting (Tom) does this mean, i

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Clemens Schwaighofer
On 02/05/2008 11:38 AM, Tom Lane wrote: > Clemens Schwaighofer <[EMAIL PROTECTED]> writes: >> * Disallow database encodings that are inconsistent with the server's >> locale setting (Tom) > >> does this mean, if my server LOCALE is for example UTF-8.en_US, and I want >> to create a EUC_JP databa

Re: [GENERAL] Question for Postgres 8.3

2008-02-04 Thread Tom Lane
Clemens Schwaighofer <[EMAIL PROTECTED]> writes: > * Disallow database encodings that are inconsistent with the server's > locale setting (Tom) > does this mean, if my server LOCALE is for example UTF-8.en_US, and I want > to create a EUC_JP database it gets rejected? do I missunderstand that?

[GENERAL] Question for Postgres 8.3

2008-02-04 Thread Clemens Schwaighofer
hi, on the page: in point E.1.2.3: * Disallow database encodings that are inconsistent with the server's locale setting (Tom) does this mean, if my server LOCALE is for example UTF-8.en_US, and I want to create a EUC_JP database i