Using the driver with iODBC driver manager

iODBC compatibility

The iODBC driver manager doesn’t fully support certain ODBC data types, which may result in incorrect data handling. The affected data types include:

  • SQL_WCHAR
  • SQL_WVARCHAR
  • SQL_WLONGVARCHAR

Recommended alternative data types

To ensure proper data processing, use the following data types instead:

  • SQL_CHAR
  • SQL_VARCHAR
  • SQL_LONGVARCHAR

Note

If your application requires SQL_WCHAR, SQL_WVARCHAR, or SQL_WLONGVARCHAR data types, it’s recommended to use the unixODBC driver manager instead of iODBC to ensure full compatibility and accurate data handling.