Problems with UTF8 in PSQL

From: rolf <rolf(dot)frogs(at)t-online(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problems with UTF8 in PSQL
Date: 2006-07-12 11:29:44
Message-ID: 200607121329.45125.rolf.frogs@t-online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hallo,

I don't know if the problem has been reported yet, but it seems to have more
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=> \d
FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xfc6d6572220a
test=> \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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2006-07-12 14:40:23 Re: BUG #2524: Error while using pg_restore command
Previous Message Sudarshan 2006-07-12 08:32:07 BUG #2524: Error while using pg_restore command