The internal JDBC driver has been modified to efficiently transfer unichar data between SQL and Java contexts.
Going from SQL to Java, the class java.sql.ResultSet provides a number of “get” methods to retrieve data from the columns of a result set. Any of these get methods work with columns defined as unichar or univarchar. The method getString() is particularly efficient since no conversion needs to be performed.
Going from Java to SQL should be done using the setString() method of the class java.sql.PreparedStatement. The internal JDBC driver copies Java string data directly into the SQL parameter defined as unichar or univarchar.
The external JDBC driver (jConnect) has been modified to support the same seamless interface as the internal driver.