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: (view raw or whole thread)
Lists: pgsql-jdbc

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

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.


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?




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-2015 The PostgreSQL Global Development Group