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

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
>