bug=# select * from example_objects where name = 'Модемы';
object_id | name
-----------+--------
2 | Мебель
2 | Модемы
(записей: 2)
bug=# select version();
version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.3.3 20040216 (Red Hat Linux
3.3.3-2.1)
(1 запись)
Do the following in an installation initdb'd in ru_RU.KOI8-R (It doesn't
happen if you initdb'd with UTF-8). You need to run psql in a locale
that is capable of russian letters, namely an UTF-8 locale, or a KOI8-R
locale. Then:
CREATE DATABASE bug WITH ENCODING='unicode';
\c bug
\i dump.sql
-- here you have to set client_encoding if you chose ru_RU.KOI8-R as the
locale for psql
-- set client_encoding to koi8r;
select * from example_objects where name = 'Модемы';
dump.sql is attached, the select statement is included in UTF-8.
Let me know if anything is missing.
--
Markus Bertheau <twanger@bluetwanger.de>