skip to main content
Connection property descriptions : StringInputParameterType
  

Try DataDirect Drivers Now

StringInputParameterType

Purpose

Determines whether the driver sends String input parameters to the database in Unicode or in the default character encoding of the database.

Valid values

nvarchar | varchar

Behavior

If set to nvarchar, the driver sends String input parameters to the database in Unicode.
If set to varchar, the driver sends String input parameters to the database in the default character encoding of the database. This value can improve performance because the server does not need to convert Unicode characters to the default encoding.

Notes

If a value is specified for the CodePageOverride property and this property is set to nvarchar, this property is ignored and a warning is generated.

Data source method

setStringInputParameterType

Default

nvarchar

Data type

String

See also

Performance considerations