Re: About ERROR: could not convert UTF-8 character 0x00e9

[Ying Lu <ying_lu@xxxxxxxxxxxxxxx>]

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" <ying_lu@xxxxxxxxxxxxxxx>
> To: <pgsql-general@xxxxxxxxxxxxxx>
> Sent: Wednesday, April 13, 2005 5:49 PM
> Subject:  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