The internal JDBC driver efficiently transfers 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, unitext, or univarchar. The method getString() is particularly efficient since no conversion needs to be performed.
Use the setString() method of the class java.sql.PreparedStatement to go from Java to SQL. The internal JDBC driver copies Java string data directly into the SQL parameter defined as unichar, unitext, or univarchar.
The external JDBC driver (jConnect) has been modified to support the same seamless interface as the internal driver.