using 8 bit ascii
От | Jason Tesser |
---|---|
Тема | using 8 bit ascii |
Дата | |
Msg-id | 04875CB4331F0240A0AD66F9709786510272AC98@paul обсуждение исходный текст |
Ответы |
Re: using 8 bit ascii
Re: using 8 bit ascii |
Список | pgsql-jdbc |
I have a Postgres database (version 7.4.2) that is using acsii character 233 which is an 8 bit ascii character. I also use jboss. My problem is when I try to retrieve a resultset that has a record with one of the 8bit ascii characters I get a message from jboss (see error message below. My question is there a way to configure the postgres jdbc driver to allow for this range of characters? 2004-10-26 16:54:51,167 ERROR [STDERR] org.postgresql.util.PSQLException: 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. 2004-10-26 16:54:51,167 ERROR [STDERR] at org.postgresql.core.Encoding.decodeUTF8(Encoding.java:287) 2004-10-26 16:54:51,167 ERROR [STDERR] at org.postgresql.core.Encoding.decode(Encoding.java:182) 2004-10-26 16:54:51,167 ERROR [STDERR] at org.postgresql.core.Encoding.decode(Encoding.java:198) 2004-10-26 16:54:51,167 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1Resul tSet.java:201) 2004-10-26 16:54:51,167 ERROR [STDERR] at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getString(AbstractJdbc1Resul tSet.java:475) 2004-10-26 16:54:51,168 ERROR [STDERR] at payroll.DeptWorkers.loadWorkers(DeptWorkers.java:52) 2004-10-26 16:54:51,168 ERROR [STDERR] at org.apache.jsp.manager_jsp._jspService(manager_jsp.jav
В списке pgsql-jdbc по дате отправления: