Skip site navigation (1) Skip section navigation (2)

Re: locale and character set

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: locale and character set
Date: 2005-03-31 13:59:17
Message-ID: 200503311559.17801.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-admin
Am Donnerstag, 31. März 2005 15:49 schrieb Tsirkin Evgeny:
> Is there any relation between the locale and character set?

Every locale expects a certain character set to be used.  You can find that 
out using

$ LC_ALL=foo locale charmap

If you want things to function correctly, you have to use a character set that 
matches the one the locale expects.

> For example if i store the data as sql_ascii can i still use the locale
> as utf-8?
> In my case i have the data stored as ascii but i just know it is
> actually utf-8 and i am doing upgrade ,

That should work, but of course you have no guarantees that the UTF-8 is 
valid, so the sorting routines and others may behave erratically if they find 
an error.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

pgsql-admin by date

Next:From: Joel FradkinDate: 2005-03-31 14:00:59
Subject: Re: connectivity to database been an issue for me.
Previous:From: Tsirkin EvgenyDate: 2005-03-31 13:49:43
Subject: locale and character set

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group