| From: | tolik(at)aaanet(dot)ru (Anatoly K(dot) Lasareff) |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | locale and multibyte together in 7.1 |
| Date: | 2001-01-15 15:41:13 |
| Message-ID: | 86ae8s3js6.fsf_-_@tolikus.hq.aaanet.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I use Postgres 7.1, FreeBSD 4.0
I configure, build and install it with:
./configure --enable-locale --enable-multibyte --with-perl
gmake
gmake install
initdb -E KOI8
The problem is: when database encoding and client encoding are
different then 'locale' features, such as 'upper' etc don't work. When these
two encodings are equal - all is OK.
Example, commets are marked by -->:
tolik=# \l
List of databases
Database | Owner | Encoding
-----------+-------+----------
cmw | cmw | ALT
template0 | tolik | KOI8
template1 | tolik | KOI8
tolik | tolik | ALT --> database 'tolik' has ALT (one of
russian) encoding
(4 rows)
tolik=# \c
You are now connected to database tolik as user tolik.
tolik=# \encoding KOI8 --> I change client encoding to KOI8,
another russian encoding
tolik=# select upper ('выбор'); --> argument is russian word in
lowercase
upper
-------
выбор --> result don't change
(1 row)
tolik=# \encoding ALT --> I set client encoding equals
to DB encoding
tolik=# select upper ('выбор');
upper
-------
ВЫБОР --> Now it works, result is the
same word in uppercase :(
(1 row)
I did'nt observe this feature in 6.* versions of Postgres.
Any ideas? Or help?
--
Anatoly K. Lasareff Email: tolik(at)aaanet(dot)ru
http://tolikus.hq.aaanet.ru:8080 Phone: (8632)-710071
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rehak Tamas | 2001-01-15 16:11:38 | Re: copy from stdin; bug? |
| Previous Message | Tom Lane | 2001-01-15 15:06:12 | Re: subselect bug? |