Skip site navigation (1) Skip section navigation (2)

Re: Problems with UTF8 in PSQL

From: REISS Thomas DSIC DESP <thomas(dot)reiss(at)interieur(dot)gouv(dot)fr>
To: rolf(dot)frogs(at)t-online(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Problems with UTF8 in PSQL
Date: 2006-07-12 14:48:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

When I experience the problem, the current Linux locale on my server is 
fr_FR(at)euro(dot) Psql works fine if I change the current locale (by setting 
the LANG shell variable) to fr_FR(at)UTF-8(dot)

I would be glad if psql may work fine without changing the LANG variable 
in the current session.


rolf a écrit :
> 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
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend


Thomas REISS
Ministère de l'Intérieur et de l'Aménagement du Territoire
Tél. : 01-61-44-25-90
E-mail: thomas(dot)reiss(at)interieur(dot)gouv(dot)fr 

In response to

pgsql-bugs by date

Next:From: Steve McWilliamsDate: 2006-07-12 16:51:56
Subject: BUG #2525: "No buffer space available" error running pg_dump on win2k for large bytea values
Previous:From: Magnus HaganderDate: 2006-07-12 14:40:23
Subject: Re: BUG #2524: Error while using pg_restore command

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group