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
$ 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
In response to
pgsql-admin by date
|Next:||From: Joel Fradkin||Date: 2005-03-31 14:00:59|
|Subject: Re: connectivity to database been an issue for me.|
|Previous:||From: Tsirkin Evgeny||Date: 2005-03-31 13:49:43|
|Subject: locale and character set|