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

Is this error correct/possible?

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Is this error correct/possible?
Date: 2005-08-23 09:55:14
Message-ID: 1124790915.27046.25.camel@panoramix.askesis.nl (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

I have a database which is created in PostgreSQL 8.0.3 which is filled
with a PostgreSQL 7.4.7 database backup. Both databases where created
with SQL_ASCII.

Running a query against on of the tables gives this error (with the
pg74.216.jdbc3.jar and postgresql-8.0-312.jdbc3.jar drivers):

"Invalid character data was found.  This is most likely caused by stored
data containing characters that are invalid for the character set the
database was created in.  The most common example of this is storing
8bit data in a SQL_ASCII database."

Inspection of the row (using pgadmin3) shows that there is the char "ü"
in a char(40) columns.

Questions:

1. Is a "ü" allowed in a SQL_ASCII database and a column of char(40)?
2. If so, is this a JDBC bug?
3. If not, is this a PostgreSQL bug, allowing a non-allowed character in
a column?

TIA

Joost

Responses

pgsql-jdbc by date

Next:From: Marc HerbertDate: 2005-08-23 13:42:21
Subject: Re: Is this error correct/possible?
Previous:From: Kris JurkaDate: 2005-08-22 20:49:45
Subject: Re: Problem with to_date function

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