|Troubleshooting and Support ||
This section contains information about issues that have been identified by 1010data as suboptimal or inherent in the design of the 1010data ODBC driver. When practical, a workaround will be provided to avoid potential issues before they arise.
1010data does not distinguish between wide and non-wide character columns, all data is stored as UTF-8 in the system, even strictly ASCII columns. However, the 1010data ODBC driver is an ANSI driver, meaning it doesn't support wide character encodings.
In practical terms, this means that the ODBC driver does not offer support for the SQL data type: SQL_C_WCHAR. If this data is requested, an error is thrown.
To avoid this issue, applications should be not be configured to request wide character data. At a lower level, if possible, applications should be configured to request SQL_C_CHAR data and anticipate that proper UTF-8 encoded data will be returned instead.