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.Elphick@lfix.co.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