Thread: 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
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@cs.concordia.ca> 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 >
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@cs.concordia.ca> > 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
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@cs.concordia.ca> >> 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
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@cs.concordia.ca> To: "Ying Lu" <ying_lu@cs.concordia.ca>; <pgsql-general@postgresql.org> Sent: Wednesday, April 13, 2005 10:48 PM Subject: Re: [GENERAL] 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@cs.concordia.ca> >>> 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >