Re: Very strange Error in Updates

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Very strange Error in Updates
Date: 2004-07-15 06:02:08
Message-ID: Pine.BSO.4.56.0407150056540.20585@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dario V. Fassi 2004-07-15 06:02:21 Re: Very strange Error in Updates
Previous Message Dario V. Fassi 2004-07-15 05:57:22 Re: Very strange Error in Updates

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dario V. Fassi 2004-07-15 06:02:21 Re: Very strange Error in Updates
Previous Message Dario V. Fassi 2004-07-15 05:57:22 Re: Very strange Error in Updates