Problems with UTF8 in PSQL - Mailing list pgsql-bugs

From rolf
Subject Problems with UTF8 in PSQL
Date
Msg-id 200607121329.45125.rolf.frogs@t-online.de
Whole thread Raw
Responses Re: Problems with UTF8 in PSQL
List pgsql-bugs
Hallo,

I don't know if the problem has been reported yet, but it seems to have mor=
e=20
implications.

- Prerequisite:
  o PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.4
     20060507 (prerelease) (Debian 4.0.3-3)
  o and psql
  o A database which was created with -E UTF8
- Description:
  If i log in into that database (client encoding is also in UTF8) a lot
  of  "\"-commands are not accepted and the error message says
  "invalid byte sequence for UTF8...."

- Original output:
  test=3D> \d
  FEHLER:  ung=FCltige Byte-Sequenz f=FCr Kodierung =BBUTF8=AB: 0xfc6d65722=
20a
  test=3D> \q

  Same error message is in the log file

-Implications?
  There are also problems in this field, if I try to add a constraint for a
  primary key from inside of another programming language with the same
  error message! So it could be a problem from PostqreSQL not from psql.

HTH to find the problem
Bye
rolf

pgsql-bugs by date:

Previous
From: "Sudarshan"
Date:
Subject: BUG #2524: Error while using pg_restore command
Next
From: "Magnus Hagander"
Date:
Subject: Re: BUG #2524: Error while using pg_restore command