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.