jdbc odbc bridge fetching text with german umlauts?

Question

Java

Good day ...
Faced such a problem - when taking from the Microsoft Access database, German letters with umlauts are lost - question marks appear instead of them.
Connection String - jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:{long_path here}/data/\sospos.mdb
Driver - sun.jdbc.odbc.JdbcOdbcDriver
Tried to solve adding charSet to connection properties but didn't work.
If anyone knows how to fix this, please share.

Answer 1

There seems to be some problem with encodings in this driver.
bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277
stackoverflow.com/questions/1467412/reading-unicode-data-from-an-access-database-using-jdbc

Answer 2

[Offtopic] Get rid of Access, it's terrible.