Re: UTF8

From: Bakos Sandor <dr_saca(at)freemail(dot)hu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: UTF8
Date: 2006-06-02 17:27:42
Message-ID: 4480750E.9000900@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)opencloud(dot)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
>
>
>

In response to

  • Re: UTF8 at 2006-06-02 09:23:39 from Marc Herbert

Browse pgsql-jdbc by date

  From Date Subject
Next Message rcolmegna@tiscali.it 2006-06-03 07:27:47 R: Re: CachedRowSet insertion problem with serial PK
Previous Message Oliver Jowett 2006-06-02 15:47:10 Re: CachedRowSet insertion problem with serial PK