11. Understanding JDBC Connectivity : JDBC Implementation Considerations : National Character Set Columns
 
Share this page                  
National Character Set Columns
The JDBC Driver supports the Ingres data types of nchar, nvarchar, and long nvarchar. Retrieval of National Character Set values is done transparently through the existing getXXX() ResultSet methods.
When using character parameters for a PreparedStatement, the data type sent by the driver is determined by the JDBC methods used to assign the parameter value, and the data types supported by the target database.
The JDBC parameter methods and resulting Ingres parameter data type for both standard and National Character Set databases are as follows:
Method
Standard Data Type
NCS Database Data Type
setString()
varchar
nvarchar
setAsciiStream()
long varchar
long nvarchar
setUnicodeStream()
long varchar
long nvarchar
setCharacterStream()
long varchar
long nvarchar
setObject( char[] )
char
nchar
setObject(String)
varchar
nvarchar
setObject(Reader)
long varchar
long nvarchar
setObject(obj,CHAR)
char
nchar
setObject(obj,VARCHAR)
varchar
nvarchar
setObject(obj,LONGVARCHAR)
long varchar
long nvarchar
setObject(char[],OTHER)
char
char
setObject(String,OTHER)
varchar
varchar
setObject(Reader,OTHER)
long varchar
long varchar
Note:  The driver's use of National Character Set parameters can be overridden using the JDBC SQL type of OTHER in the setObject() method.