Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

JDBC-ODBC Bridge does not support Unicode UTF-16

  Asked By: Howard    Date: Jun 23    Category: Java    Views: 2147

I'm using Jdeveloper 10.0.3 IDE in order to develop an application for
data transformation between MS Access 2003 (source) and Oracle 10g
(destination). Clients use Windows XP.

JDBC-ODBC Bridge still does not support Unicode UTF-16 which is the
Charest used by MS Access 2000/2003.
Note that when I changed locale in regional setting, destination
Connection to Ora10g failed to open a connection, it works only with
English locale, so I can't change my locale information.
How can I read Unicode from source DB?



1 Answer Found

Answer #1    Answered By: Ted Thibodeau Jr     Answered On: Oct 17

Try using another JDBC-to-ODBC Bridge.

The bridge that's built into the JVM is a proof-of-concept implementation, available as a last resort when there is no other way to make a JDBC connection. Sun documented this long ago, and Oracle hasn't changed that doc yet (so far as I've seen).

My employer, OpenLink Software, produces a couple of JDBC-to-ODBC [1][2] options, as well as JDBC drivers for several DBMS. All of these fully support Unicode data.

[1] Single-Tier JDBC Driver for ODBC Data Sources - http://uda.openlinksw.com/jdbc-odbc-st/
[2] Multi-Tier JDBC Driver for ODBC Data Sources - http://uda.openlinksw.com/jdbc-odbc-mt/

I hope this helps future seekers, even if it's too late for you, Howard!

Be seeing you,

OpenLink Support

Didn't find what you were looking for? Find more on JDBC-ODBC Bridge does not support Unicode UTF-16 Or get search suggestion and latest updates.