Re: About ERROR: could not convert UTF-8 character 0x00e9 - Mailing list pgsql-general

From Ying Lu
Subject Re: About ERROR: could not convert UTF-8 character 0x00e9
Date
Msg-id 425D6B4A.4010003@cs.concordia.ca
Whole thread Raw
In response to Re: About ERROR: could not convert UTF-8 character 0x00e9 to ISO8859-1  (Secrétariat <ets@rolland-fr.com>)
Responses Re: About ERROR: could not convert UTF-8 character 0x00e9
List pgsql-general
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



pgsql-general by date:

Previous
From: James Robinson
Date:
Subject: Re: Composite type versus Domain constraints.
Next
From: Libia Andrea Ramos Sánchez
Date:
Subject: [PHP] unsubscribe