Re: Encoding problem with 7.4

> 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