Re: Encoding problem with 7.4 - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Encoding problem with 7.4
Date
Msg-id 3FCE4DFF.8060103@dunslane.net
Whole thread Raw
In response to Re: Encoding problem with 7.4  ("E.Rodichev" <er@sai.msu.su>)
Responses Re: Encoding problem with 7.4
List pgsql-hackers
E.Rodichev wrote:

>On Wed, 3 Dec 2003, Stephan Szabo wrote:
>
>  
>
>>On Wed, 3 Dec 2003, E.Rodichev wrote:
>>
>>    
>>
>>>On Fri, 28 Nov 2003, Tom Lane wrote:
>>>
>>>      
>>>
>>>>"E.Rodichev" <er@sai.msu.su> writes:
>>>>        
>>>>
>>>>>/e:2>createdb test
>>>>>          
>>>>>
>>>>> test      | er       | SQL_ASCII   <----- Incorrect!
>>>>>(3 rows)
>>>>>          
>>>>>
>>>>>Let's note than the last line is in fact completely incorrect.
>>>>>          
>>>>>
>>>>What's incorrect about it?  You didn't ask for any other encoding
>>>>than SQL_ASCII.
>>>>        
>>>>
>>>It is incorrect, because database "test" is, really, in KOI8, NOT in SQL_ASCII
>>>in this example, as I explained in my mail.
>>>      
>>>
>>No, it isn't. As far as PostgreSQL is concerned the database is SQL_ASCII
>>since you didn't override the default encoding at initdb time or at
>>createdb time.  You did choose LC_ values that seem to want KOI8, but
>>locale and encoding are separate, if you want KOI8 encoding, you have to
>>say so.
>>    
>>
>
>Yes, it is!
>
>If db "test" is SQL_ASCII, AND all LC_* env are set to "C", the sorting of
>ASCII characters is, for example,
>
>a
>A
>b
>B
>c
>C
>
>not
>
>A
>B
>C
>a
>b
>c
>
>(the first order is true for ru_RU.KOI8-R, the latter one - for C).
>
>To summarize shortly:
>
>- initdb _without_ -E flag, but with ru_RU.KOI8-R environment;
>- createdb with any environment;
>- psql indicates SQL_ASCII;
>- sorting and upper/lowercasing are in ru_RU.KOI8-R, even with LC_*
>environment is set to "C".
>
>Where is the logic?
>  
>


Encoding and collation order are two different things. LC_* settings 
have no effect on encoding.

see http://www.postgresql.org/docs/current/static/charset.html

cheers

andrew




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Encoding problem with 7.4
Next
From: Stephan Szabo
Date:
Subject: Re: Encoding problem with 7.4