This section describes the general functionality supported by the driver.

  • ODBC Compliance: The driver is Level 1 compliant, that is, it supports all ODBC Core and Level 1 functions.
    In addition, the following functions are supported:
    • SQLColumnPrivileges
    • SQLForeignKeys
    • SQLTablePrivileges

    Refer to ODBC API and scalar functions in the Progress DataDirect for ODBC Drivers Reference for a list of supported API functions.

  • Unicode support: When the character set of a character column is Unicode, the driver maps the MySQL data type to Unicode data type as follows:
    MySQL Data Type Unicode Data Type
    CHAR SQL_WCHAR
    LONGTEXT SQL_WLONGVARCHAR
    MEDIUMTEXT SQL_WLONGVARCHAR
    TEXT SQL_WLONGVARCHAR
    TINYTEXT SQL_WLONGVARCHAR
    VARCHAR SQL_WVARCHAR

    Refer to Internationalization, localization, and Unicode in the Progress DataDirect for ODBC Drivers Reference for details.

  • Isolation and lock levels: The driver supports isolation levels 0 (read uncommitted), 1 (read committed), 2 (repeatable read), and 3 (serializable). The default is 1. In addition, it supports record-level locking.

    Refer to Locking and isolation levels in the Progress DataDirect for ODBC Drivers Reference for details.

  • Connections and statements supported: The driver supports multiple connections and multiple statements per connection.