Re: UTF8 - Mailing list pgsql-jdbc

From Bakos Sandor
Subject Re: UTF8
Date
Msg-id 4480750E.9000900@freemail.hu
Whole thread Raw
In response to Re: UTF8  (Marc Herbert <Marc.Herbert@continuent.com>)
List pgsql-jdbc
Hi !

I set the character encoding in the InputStreamReader in my program and
it seem this is resolve my problem.
So thx for all the help.

Saca

Marc Herbert wrote:
>Oliver Jowett <oliver@opencloud.com> writes:
>
>
>>Markus Schaber wrote:
>>
>>>Hi, Bakos,
>>>Bakos Sandor wrote:
>>>
>>>
>>>>I get the following exception when I read a simple TXT file in Linux and
>>>>try to INSERT to the psql. (8.1.4)
>>>>
>>>>org.postgresql.util.PSQLException: ERROR: character 0xefbfbd of encoding
>>>>"UTF8" has no equivalent in "LATIN2"
>>>>
>
>
>
>>I would guess that the problem is probably that when *reading* the
>>text file originally, the wrong encoding is being used to convert the
>>bytes to Java Strings. If you don't use the right encoding here, then
>>the Java String you end up with will be garbage.
>>
>
>Very likely since 0xefbfbd is the... unicode "replacement character"
>
> http://www.fileformat.info/info/unicode/char/fffd/index.htm
>
>Try printing this file from Java for debugguing.
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: Don't 'kill -9' the postmaster
>
>
>


pgsql-jdbc by date:

Previous
From: Marc Herbert
Date:
Subject: Re: UTF8
Next
From: "rcolmegna@tiscali.it"
Date:
Subject: R: Re: CachedRowSet insertion problem with serial PK