Re: Character encodings...

Michael Sobolev wrote:
>On Thu, Apr 13, 2000 at 11:54:17AM +0100, Oliver Elphick wrote:
>> Turn on logging in the backend (edit /etc/postgresql/postmaster.init) and
>> restart the postmaster (/etc/init.d/postgresql restart). See what you get
>> in the log.
>What level of debug should be sufficient?

2

Also set PGECHO in postmaster.init, so that queries are echoed in the log.

>I've got an impression that it's psql that does not process correctly the
>stuff.
>
>I have a very simple statement:
>
> insert into news values ('2000-04-13', NULL, '');
>
>This works just fine. Now I replace '' with 'A' (A -- 65). It still works
>just fine. Now I replace this latin A with Russian A. And psql shows:
>
>$ psql -f test.sql stuff
>insert into news values ('2000-04-12', NULL, 'á');
>EOF

The trouble is, I don't know how to test this. How do I produce Russian
characters on an English keyboard?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"I sought the LORD, and he heard me, and delivered me
from all my fears." Psalms 34:41