Re: [BUGS] Bug #3924: Create Database with another encoding as the encoding from postgres

2008-10-30 Thread Joe
Tom Lane wrote: Plan B would be to set the database locale to C, which is encoding-agnostic and hence allows different databases to have different encodings. Do you actually need en_US sort order? I wasn't aware of the difference in sort orders until about two months ago when i had to comp

Re: [BUGS] Bug #3924: Create Database with another encoding as the encoding from postgres

2008-10-30 Thread Tom Lane
Joe <[EMAIL PROTECTED]> writes: > Going back to my options, are you saying that if I re-initdb the 8.3 > cluster to UTF8, restore the LATIN1 db as UTF8, and then do "set > client_encoding = LATIN1" in the application code, then everything will > work fine, even if the machine locale remains en_U

Re: [BUGS] Bug #3924: Create Database with another encoding as the encoding from postgres

2008-10-30 Thread Joe
Hi Tom, Tom Lane wrote: Why does it have to be LATIN1? If your answer is "my client code deals in LATIN1", just set client_encoding = LATIN1. You could do that with ALTER DATABASE SET or possibly ALTER USER SET so that it's transparent to the clients. The client code is primarily encoding

Re: [BUGS] Bug #3924: Create Database with another encoding as the encoding from postgres

2008-10-30 Thread Tom Lane
Joe <[EMAIL PROTECTED]> writes: > I can understand that creating a LATIN2, EUC_CN or some other encoding > in a LATIN1 cluster may cause problems, but don't quite see how UTF-8 > can be a problem since in essence it includes the others. Perhaps > someone can provide further explanation? The lo

[BUGS] Bug #3924: Create Database with another encoding as the encoding from postgres

2008-10-30 Thread Joe
Hi, I just run into this bug (http://archives.postgresql.org/pgsql-bugs/2008-02/msg00010.php). In my case, Roundup (Python bug tracker) is trying to CREATE DATABASE WITH ENCODING='UNICODE' in an 8.3.4 cluster created with LATIN1 encoding, and it gets the error: encoding UTF8 does not match

Re: [BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Heikki Linnakangas
Stefan Kunick wrote: PostgreSQL version: 8.3RC2 Operating system: Windows Longhorn Description:Create Database with another encoding as the encoding from postgres Details: I installed postgres with the encoding 1252. After this, i started the program createdb (createdb -E LATIN1 -O p

Re: [BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Peter Eisentraut
Stefan Kunick wrote: > I installed postgres with the encoding 1252. After this, i started the > program createdb (createdb -E LATIN1 -O postgres -p -U postgres). The > program stopped with the error message: createdb: database creation failed. > Error: encoding LATIN1 does not match server's l

[BUGS] BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-02 Thread Stefan Kunick
The following bug has been logged online: Bug reference: 3924 Logged by: Stefan Kunick Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Windows Longhorn Description:Create Database with another encoding as the encoding from postgres Detail