This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes JDBC Driver that can extract Greek Characters from MsAccess Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC Driver that can extract Greek Characters from MsAccess " Watch "JDBC Driver that can extract Greek Characters from MsAccess " New topic
Author

JDBC Driver that can extract Greek Characters from MsAccess

Alex Sean
Greenhorn

Joined: Jun 25, 2009
Posts: 3
Hello everyone!

I am trying to retrieve greek characters such as the ohm symbol from the MS Access database. Unfortunately, the sun.jdbc.odbc.JdbcOdbcDriver has issues with this:

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277

I know it says that the this bug might be fixed in JDK 7, but I do want that "solution"

Is there are alternative jdbc Driver that I could use? Are there any other way in other to retrieve such data?

Thanks! I will appreciate your help


Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You'll need a commercial driver for this I'm afraid, there are no free ones that I am aware of. Given access's considerable limitations is there any scope for porting your schema to another, better database (e.g. MySQL)?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC Driver that can extract Greek Characters from MsAccess