ODBC Driver for SugarCRM

Supported Data Types - ODBC Driver for SugarCRM



Data Type Mapping

The Devart ODBC Driver for SugarCRM supports all SugarCRM data types.

The following table describes how the SugarCRM data types are mapped to the ODBC data types.

SugarCRM Data Types ODBC Data Types

BINARY

SQL_VARBINARY

STRING

SQL_VARCHAR

SQL_LONGVARCHAR

SQL_WVARCHAR

SQL_WLONGVARCHAR

BOOLEAN

SQL_BIT

BYTE

SQL_TINYINT

INTEGER

SQL_INTEGER

SQL_SMALLINT

DOUBLE

SQL_FLOAT

SQL_DOUBLE

TIME

SQL_TYPE_TIME

DATE

SQL_TYPE_DATE

DATETIME

SQL_TYPE_TIMESTAMP

© 2015-2024 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback