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 425D858F.9050902@cs.concordia.ca
Whole thread Raw
In response to Re: About ERROR: could not convert UTF-8 character 0x00e9  (Ying Lu <ying_lu@cs.concordia.ca>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Libia Andrea Ramos Sánchez
Date:
Subject: [PHP] unsubscribe
Next
From: Scott Ribe
Date:
Subject: Re: Postgresql 8.0.2 and Tiger?