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.

Default

nvarchar

Data Type

String

See also

Performance Considerations