Hello,
Actually, both the server and client sides have been setup encoding "latin1".
I am trying to read data from one DB and save to another DB. When I tried to read data from one DB (using postgresql-8.0-310.jdbc3.jar), it seems that I lost all my French characters (they become ?).
Also, I am *not* able even to *paste* french characters from PSQL terminal.
I am thinking should I make some changes about my terminal drivers to allow French characters?
(Note: I already tried javac -encoding ISO-8859-1 java -Dfile.encoding=ISO-8859-1 test When compiling and running my java programs )
Thanks a lot, Emi
SET CLIENT_ENCODING TO 'LATIN1' ; SELECT * FROM table1 ;
Your database woul be coded as LATIN1.
Luc
----- Original Message ----- From: "Ying Lu" <[EMAIL PROTECTED]>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, April 13, 2005 5:49 PM
Subject: [GENERAL] About ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1
Greetings,
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2. When I run
select * from table1;
I got an error: ========= ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1
I tried to google but cannot find much info about it. Can somebody help?
Thanks, Emi
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
