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

["Ets ROLLAND" <ets@xxxxxxxxxxxxxx>]

Hello !

I was out today ...
In order to translate from heterogeneous Databases, you must have to change 
the client side encoding :
I've done between an SCO UNIX 3.2 v4.2 using PROGRESS V6 and a Windows 2003 
server
using PostgreSQL 8.0.
If you are using PGadmin 3 use :
SET CLIENT_ENCODING TO 'xxx'  (see the encoding of you source DB).
If it is psql, you can create a script loading psql beginning with :
@REM psql.cmd : Chargement de PostgreSQL PSQL
@cmd.exe /c chcp 1252
@"C:\Program Files\PostgreSQL\8.0\bin\psql.exe" -h localhost -p 5432 
template1 postgres
for instance.

Luc

----- Original Message ----- 
From: "Ying Lu" <ying_lu@xxxxxxxxxxxxxxx>
To: "Ying Lu" <ying_lu@xxxxxxxxxxxxxxx>; <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, April 13, 2005 10:48 PM
Subject: Re:  About ERROR: could not convert UTF-8 character 0x00e9


> Luc,
>
> You are right. I am afraid that I checked different mahine's 
> client_encoding, which have been setup the correct encodings.
>
> While for my working environment, I have
>
> CLIENT_ENCODING = SQL_ASCII ;
> SERVER_ENCODING = SQL_ASCII;
>
> After we setup the correct encoding for client and server side, we should 
> be able to read correct French characters through JDBC.
>
> However, I am still *not able* to *paste French Characters* such as ç 
> *directly from PSQL terminal *screen.
>
> Please advise,
> Emi
>
>
>
> > 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings