The following table lists parameter and result set data.
The new driver strictly adheres to the exact conversion from the application character set to the session character set regardless of unicode vs non-unicode. The following table shows the conversion for Parameter, and Result Set is the opposite.
| Session Character Set ASCII or User-defined | Session Character Set Non-Unicode |
Session Character Set Unicode | |
|---|---|---|---|
| SQL_C_CHAR | No Conversion | Convert from Application Code Page to Unicode | Convert from Application Code Page to Unicode |
| SQL_C_WCHAR | Convert from Application Code Page to Platform Unicode representation | Convert from Session Character Set to the Platform Unicode representation (UTF8 on the UNIX OS, UTF32 on Apple macOS, and UTF16 on Windows) | No Conversion when session character set matches the Platform Unicode representation (UTF8 on the UNIX OS, and UTF16 on Windows. On Apple macOS, convert from session character set to UTF32 Unicode representation. |