Specify your codepage :
SET CLIENT_ENCODING TO 'LATIN1' ;
SELECT * FROM table1 ;
Your database woul be coded as LATIN1.
Luc
----- Original Message -----
From: "Ying Lu" <ying_lu(at)cs(dot)concordia(dot)ca>
To: <pgsql-general(at)postgresql(dot)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
>