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
theirdatabase (decimal 32 to 126 in most columns, decimal 10 also allowed in some).  They would prefer to see
exceptionsfrom the JDBC driver on attempts to insert or retrieve any character outside the ASCII range than to have it
silentlywritten or returned. 

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

Thanks,

-Kevin


>>> Kris Jurka <books@ejurka.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