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

Re: Encoding problem with 7.4

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: "E(dot)Rodichev" <er(at)sai(dot)msu(dot)su>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Encoding problem with 7.4
Date: 2003-11-28 01:20:12
Message-ID: 3FC6A2CC.1090708@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
> After installing 7.4 I created database completely from scratch
> with cyrillic locale:
> 
> su postgres
> export LC_CTYPE=ru_RU.KOI8-R
> export LC_COLLATE=ru_RU.KOI8-R
> /usr/local/pgsql/bin/initdb -D /db2/pgdata

You need to go:

/usr/local/pgsql/bin/initdb -D /db2/pgdata -E KOI8

To set the default encoding to KOI8.

> Then I switch off to my normal account. At this point I have:
> 
> /e:1>psql -l
>         List of databases
>    Name    |  Owner   | Encoding
> -----------+----------+-----------
>  template0 | postgres | SQL_ASCII
>  template1 | postgres | SQL_ASCII
> (2 rows)

Locale and encoding are two quite different things.

Chris



In response to

pgsql-hackers by date

Next:From: Joe ConwayDate: 2003-11-28 05:38:44
Subject: Re: 7.5 Plans
Previous:From: Jean-Michel POUREDate: 2003-11-27 22:37:47
Subject: Re: Encoding problem with 7.4

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