Re[2]: cyrillic and sort order (ORDER BY) - Mailing list pgsql-general

From Mihail Marinov
Subject Re[2]: cyrillic and sort order (ORDER BY)
Date
Msg-id 12714745192.20010108232156@bcci.bg
Whole thread Raw
In response to Re: cyrillic and sort order (ORDER BY)  (Radoslaw Stachowiak <radek@alter.pl>)
List pgsql-general
RS> *** Tom Lane <tgl@sss.pgh.pa.us> [Tuesday, 02.January.2001, 18:38 -0500]:
>> To enlarge a little more: the most common way to get burnt by this is
>> to have different LC_xxx environment variables when starting the
>> postmaster from a boot script as you do when running initdb or starting
>> the postmaster from an interactive shell.  Best to explicitly set the
>> desired locale in the script that fires up the postmaster.
>>
>> Postgres 7.1 solves this problem by locking down a database's locale at
>> initdb time.  Subsequent postmaster runs will adopt the LC_COLLATE value
>> that was prevalent when initdb ran, no matter what their environment is.
>>

RS> Could You write what is suggested path to change encoding from SQLASCII to
RS> another (ISO88592) when I'd upgrade to 7.1 from 7.03 ?

RS> I know have SQLASCII, but I'll need to change it to sth more suitable.

Wouldn't it be enough to dump the database out, recreate a new one with the
required encoding, than dump it in ?



pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: Access 2000 and PostgreSQL: Record Editing Problems
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: replication followup