About ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1

Started by Ying Lualmost 21 years ago5 messagesgeneral

Jump to latest

Ying Lu

ying_lu@cs.concordia.ca

almost 21 years ago

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

Secrétariat

ets@rolland-fr.com

almost 21 years ago

In reply to: Ying Lu (#1)

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

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

Show quoted text

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

Ying Lu

ying_lu@cs.concordia.ca

almost 21 years ago

In reply to: Secrétariat (#2)

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

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

Show quoted text

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

Ying Lu

ying_lu@cs.concordia.ca

almost 21 years ago

In reply to: Ying Lu (#3)

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

Show quoted text

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

Secrétariat

ets@rolland-fr.com

almost 21 years ago

In reply to: Ying Lu (#1)

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

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

Show quoted text

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