| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-11-28 05:38:44 | Re: 7.5 Plans |
| Previous Message | Jean-Michel POURE | 2003-11-27 22:37:47 | Re: Encoding problem with 7.4 |