how to read hindi text from Ms Access database in java using JDBC?

Question

I am creating an java application which is used to read Hindi Data from ms access Database. please suggest me how to read Hindi text in java from ms access database.

code :

 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String database ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+db_path+";";  // setup the properties
            java.util.Properties prop = new java.util.Properties();
            prop.put("charSet", "UTF-8");
            prop.put("user", "");
            prop.put("password", "");



        Connection conn = DriverManager.getConnection(database, prop);

Sorry, this is not the way SO works. If you have code which causes problems you can come back. [How do I ask a good question?](http://stackoverflow.com/help/how-to-ask) — Mateusz Sroka, Jan 20 '16 at 09:10

score 1 · Answer 1 · edited May 23 '17 at 11:59

1

Java's JDBC-ODBC Bridge and the Access ODBC driver will not be able to retrieve the Unicode (Hindi) text from the database. However, the UCanAccess JDBC driver can do it. See:

Manipulating an Access database from Java without ODBC

edited May 23 '17 at 11:59

Community

1
1

answered Jan 20 '16 at 10:33

Gord Thompson

116,920
32
215
418

how to read hindi text from Ms Access database in java using JDBC?

1 Answers1