Re: Bug #814

From: Barry Lind <blind(at)xythos(dot)com>
To: Malcolm Warren <malcolm(at)villeinitalia(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug #814
Date: 2003-09-13 01:26:36
Message-ID: 3F62724C.9070400@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Malcolm,

This has been "fixed" in the latest builds of the 7.3 driver. Download
from jdbc.postgresql.org.

The "fix" was to just report a better error message in this case. If
you are storing non-ascii data, you are going to need your database to
be running with an encoding that can store that data. Thus in your
situation as you are reporting below you would need to recreate your
database in latinX or unicode.

thanks,
--Barry

Malcolm Warren wrote:
> I note that this bug was opened in December 2002.
>
> To recap, you get an ArrayIndexOutOfBoundsException at
> org.postgresql.core.Encoding.decodeUTF8 in Encoding.java line 253
> whenever it encounters a character from the extended keyboard.
>
> I have Postgres 7.3.2 with SQL_ASCII (default?) encoding and no locale.
> But a lot of the text in our database is in Italian.
> So programmes crash as soon as they meet any italian accented character
> when using the new JDBC jars.
> I come across the same bug using both the JDBC2 and JDBC3 jars.
>
> Anyone know of plans to deal with this bug? Any information would be
> gratefully received.
>
> Kind regards,
> Malcolm Warren
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-09-13 01:31:29 Re: Specification of "/" in the host name (for Unix socket
Previous Message Oliver Jowett 2003-09-13 00:05:03 Re: Specification of "/" in the host name (for Unix socket support)