Problem with Java JDBC Connection with MS Access...
Submitted by adevedo on Mon, 2007-09-24 15:15.
al salamo alikom wa rahmat allah wa barakatoh
I am making an application that uses MS Access as the back end DB, when I try to read or right data (written in arabic) on the DB using the application I found that the data encoding is wrong, I've searched for that problem and I found that the problem is in the JDBC driver because it uses UTF-8 encoding and MS Access 2000 uses UTF-16 to store and view data, but the application is required to manage the data on access and also the data should be managed from access too :(, so I've searched for a driver that uses UTF-16 and I've found one but it is commercial.
I've found a solution for the problem by turing the "Language for UNICODE applications" to be Arabic, but this is just a workaround and not a solution for the problem.
I am making this application for the 3r-Army and if this application didn't work correctly when I deliever it "for any reason", I may go to jail :D.
so do anyone knows how to make the built in JDBC driver to work with UTF-16 encoding and not UTF-8 on JDK 1.5, thanks
al salamo alikom wa rahmat allah wa barakatoh
RE: Problem with Java JDBC Connection with MS Access...
I am not so experienced with Access, but I think u can manage to chande the encoding of the saved string data for each filed u have . Did you try this ?
Hummm...
No this can't be done - I guess, to query access you have to use SQL statement(INSERT) as UTF-8 string because the JDBC-ODBC driver doesn't support UTF-16 and thats means that I have to make a string contains 2 types of encoding UTF-8 for the INSERT statement so that the driver can query the DB and UTF-16 for the values, I didn't try this before, But I think that It won't work.
well i had the same problem
well i had the same problem before with Access 2000 and i always thought it was about the Encoding, anyway the solution was in setting evreything in the Regoinal Setting in the Control Panel to the Arabic ,Arabic (Egypt) and Egypt, for sure this solution is under Windows
..........
..........