HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

problem reading LONGVARCHAR column from ResultSet	tomoko	2009-07-06 02:11:58
I have a problem reading LONGVARCHAR column from Access mdb file. I tried ResultSet.getBlob, getString, getByte, but non of them worked. How to get this column value?
Re:problem reading LONGVARCHAR column from ResultSet	HXTT Support	2009-07-06 07:48:34
But it should work normally. Please email us your mdb sample so that we can see what's your issue.
Re:Re:problem reading LONGVARCHAR column from ResultSet	tomoko	2009-07-06 15:10:49
When I debugged my code the column of ResultSet contained char[] of unreadable characters. I've set Charset to cp437 which might be wrong. What it should be when the mdb file is created on English windowsXP?
Re:Re:Re:problem reading LONGVARCHAR column from ResultSet	HXTT Support	2009-07-07 04:18:39
>What it should be when the mdb file is created on English windowsXP? If your mdbf is MS Access 95/97 format, you need to set a correct charSet to decode it. If your mdb is MS Access2000 or more latest version, you needn't to care for charSet.

Email: