Purpose

Specifies whether String columns are described as VARCHAR columns. This property affects ResultSetMetaData calls; it does not affect getTypeInfo() calls.

Valid Values

varchar | longvarchar

Behavior

If set to varchar, String columns are described as VARCHAR.

If set to longvarchar, String columns are described as LONGVARCHAR.

Notes

To obtain data from String columns with the getClob() method, the StringDescribeType connection property must be set to longvarchar. Otherwise, calling getClob() results in an "unsupported data conversion" exception.

Data Source Method

setStringDescribeType

Default

varchar

Data Type

String

See also

Performance Considerations