Re: Very strange Error in Updates - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Very strange Error in Updates
Date
Msg-id Pine.BSO.4.56.0407150056540.20585@leary.csoft.net
Whole thread Raw
In response to Re: Very strange Error in Updates  ("Dario V. Fassi" <software@sistemat.com.ar>)
Responses Re: Very strange Error in Updates
List pgsql-jdbc

On Thu, 15 Jul 2004, Dario V. Fassi wrote:

> Kris Jurka wrote:
>
> Kris, the value of field is originate from a DB2 v6.1 with encoding
> IBM-850 (Ascii PC), I don't believe that the value are unicode.

I mean that java and the jdbc driver internally represent strings with
unicode.  If any of the data has the high bit set (ASCII values > 127)
then the jdbc driver will send it as two bytes or more because it uses
UTF-8.  Normally the server will convert it from UTF-8 to the database's
encoding, but if the database is SQL_ASCII it doesn't know how to convert
it and must keep it as two bytes.  You have not told us what your
database's encoding is yet.

Kris Jurka


pgsql-jdbc by date:

Previous
From: "Dario V. Fassi"
Date:
Subject: Re: Very strange Error in Updates
Next
From: Oliver Jowett
Date:
Subject: Re: Very strange Error in Updates