> 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