1

I have MS Access database file with german umlauts in text fields. When i try to read them i have strings with ? characters instead of characters with umlauts. I try to set different characters set for database connection like properties.setProperty("charSet", "Cp1252"); but it is not work (i try cp1250, cp1251, utf8, utf16, iso-8859-1 characters sets). My system characters set is Cp1251, and when i create the MS Access database with russians characters, the russian characters imports successfully.

I found that it can be bug in the jdbc driver, but i am not sure: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277

If anybody knows how this problem can be solved, please tell me about.

Anton
  • 575
  • 2
  • 7
  • 27

1 Answers1

0

I am assuming that you are using the stock Sun implementation of the jdbc-odbc connector that has been around for years. That implementation is always described as a reference implementation and should not be used for production purposes. I have also tried using it in the past only to find significant errors and features that are unsupported (ex: foreign keys, etc). There are other commercial implementations that supposedly solve many of these problems. I say supposedly as I never bought one so I cannot vouch for their functionality, but their docs indicate that they are much more complete.

Take a look here to see if any of the listed drivers meet your needs.

I also just found JaySQL Lite. Maybe that can help you out if it meets your needs.

Eric B.
  • 23,425
  • 50
  • 169
  • 316
  • Thank you, but i need chargeless jdbc driver. – Anton Jan 26 '12 at 04:26
  • That's what I was afraid of. I had a lot of problems with that exact issue years ago, but unfortunately was unable to find anything of value. And the Sun driver has not been maintained in several years. I added a link of some existing jdbc-odbc drivers. I do not know if any are FOSS or not. – Eric B. Jan 26 '12 at 04:32