Configuring Metadata Options in Windows

You can configure how the connector handles specific types of data.

To configure metadata options in Windows:

  1. To access the metadata options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then select the Metadata tab.
  2. To return BIGINT data as SQL_INTEGER data instead of SQL_BIGINT data, select the Treat BIGINT Columns As INT Columns check box.
  3. To return Binary columns as Character columns, select the Always Handle Binary Function Results As Character Data check box.
  4. To allow column names in queries to include the database name (for example, using the format [Database].[Table].[Column]), select the Ignore Schema In Column Specifications check box.
    Note:

    If this option is disabled, the connector returns an error if a column name specified in a statement includes the database name.

  5. To return fully-qualified column names that include the table name when the SQLDescribeCol() function is called, select the Include Table Name In SQLDescribeCol() check box.
  6. To limit column sizes to 32-bit signed values, select the Limit Column Size To A Signed 32-bit Value check box.
  7. Optionally, to configure the connector to recognize table type information from the data source, select the Enable Table Types check box. For more information, see Enable Table Types.
  8. Optionally, to return default metadata as SQL_VARCHAR, select the Return Default metadata for SQLDescribeParam check box.
  9. To save your settings and close the Simba MariaDB ODBC Driver DSN Setup dialog box, click OK.