File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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.
It is sorta covered in the JavaRanch Style Guide.
subject: Non-printable chars from MS Access
Similar Threads
How to create a new method for an existing object?
JDBC & SQL Error List Help
JTextField and KeyEvents ...
Remove bad characters from strings