Use SQL_WVARCHAR instead of SQL_VARCHAR

UseWVarChar

Key Name	Default Value	Required
`UseWVarChar`	Clear (`0`)	No

Description

This option specifies how data types are mapped to SQL.

Enabled (1)1: The connector returns data as SQL_WVARCHAR data instead of SQL_VARCHAR data.
Disabled (0)0: The connector returns data as SQL_VARCHAR data.

Note:

This option applies only to result set columns that the connector would normally return as SQL_VARCHAR columns. It does not convert all columns into SQL_WVARCHAR.

Advanced Driver Configuration Options on page 1
Data Types
Configuring Advanced Options
Creating a Data Source Name
Configuring a DSN-less Connection
Using a Connection String