Specify your codepage :
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
