Re: Is this error correct/possible?

My client has a standard that only a subset of the 7 bit ASCII character set is to be allowed in character columns in their database (decimal 32 to 126 in most columns, decimal 10 also allowed in some). They would prefer to see exceptions from the JDBC driver on attempts to insert or retrieve any character outside the ASCII range than to have it silently written or returned.

In this particular case, do you see a problem with using the SQL_ASCII encoding?

Thanks,

-Kevin


>>> Kris Jurka <books(at)ejurka(dot)com> 08/23/05 9:34 AM >>>

The JDBC documentation clearly states not to choose a SQL_ASCII
database for your data.

http://jdbc.postgresql.org/documentation/80/your-database.html