File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Non-printable chars from MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Non-printable chars from MS Access" Watch "Non-printable chars from MS Access" New topic

Non-printable chars from MS Access

Richard Boren
Ranch Hand

Joined: Mar 01, 2001
Posts: 233
I am using code from Just Java 2 for accessing the MS Access sample Northwind.mdb using SQL.
To fetch the data - System.out.println( myResultSet.getString( columnNumber ) ) ; is used.
Some of the characters, like the accent, are displayed as non-printable chars. Is there a way to get all the chars to print correctly. I have looked at getAsciiStream(), but I didn't understand how to used it or know if it would even fix the problem.
I agree. Here's the link:
subject: Non-printable chars from MS Access
It's not a secret anymore!