Invalid Character Data Problem

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Cc: Postgre JDBC List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Invalid Character Data Problem
Date: 2004-11-26 21:43:42
Message-ID: BDCCE38E.4E44B%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

I am having some trouble pulling some data out from the database. I have
tried against both 7.4.5, 8.0b4 and 8.0b5 and get the same result.

I have used both the v308 and CVS HEAD of the JDBC driver.

When I SELECT from a certain table, I see this JDBC exception:

"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."

The database is indeed of type SQL_ASCII. The table stores mailing list data
and has about 400,000 rows.

Looking at the data via psql, I see that some of the rows have strange
characters in them, such as question marks where I would not expect them,
etc...

What are my options? Is there a way to identify the 'bad' records, or the
ones causing trouble?

Thanks,
Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Woodchuck Bill 2004-11-26 22:09:41 Re: comp.databases.postgresql.* groups and RFD
Previous Message Adrian Klaver 2004-11-26 21:38:52 Re: pg_dump and languages

Browse pgsql-jdbc by date

  From Date Subject
Next Message jonathan.lister 2004-11-27 13:05:37 Is there a size limit on setBinaryStream?
Previous Message Manuel Sugawara 2004-11-26 19:33:29 Re: Result set not positioned properly, perhaps you need to