Configuring Data Type Options

You can configure data type options to modify how the connector displays or returns some data types.

To configure data type options:

  1. To access data type options, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Data Type Options.
  2. To enable the connector to return data as Unicode character types, select the Use Unicode check box.

    Note:

    When the Use Unicode check box is selected, the connector does the following:

    • Returns SQL_WCHAR instead of SQL_CHAR.
    • Returns SQL_WVARCHAR instead of SQL_VARCHAR.
    • Returns SQL_WLONGVARCHAR instead of SQL_LONGVARCHAR.

  3. To configure the connector to return Boolean columns as SQL_VARCHAR instead of SQL_BIT, select the Show Boolean Column As String check box.
  4. To configure the connector to return Text columns as SQL_LONGVARCHAR instead of SQL_VARCHAR, select the Text as LongVarChar check box.
  5. To configure the connector to return Bytea columns as SQL_LONGVARBINARY instead of SQL_VARBINARY, select the Bytea As LongVarBinary check box.
  6. To configure the connector to return Money columns with non-decimal characters removed, select the Money As Decimal check box.
  7. In the Max Varchar field, type the maximum data length for VarChar columns.
  8. In the Max LongVarChar field, type the maximum data length for LongVarChar columns.
  9. In the Max Bytea field, type the maximum data length for Bytea columns.
  10. To save your settings and close the Data Type Configuration dialog box, click OK.