Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group