SQLType enumeration

Public Enum SQLType

public enum SQLType

Member name	Description
SQL_TYPE_NULL	Null data type.
SQL_UNKNOWN_TYPE	Unknown data type.
SQL_CHAR	UTF-8 character array of a set size. Has .NET type String.
SQL_NUMERIC	Numeric value of set size and precision. Has .NET type Decimal.
SQL_DECIMAL	Decimal number of set size and precision. Has .NET type Decimal.
SQL_INTEGER	32-bit integer. Has .NET type Int32.
SQL_SMALLINT	16-bit integer. Has .NET type Int16
SQL_FLOAT	Floating point number with ODBC driver defined precision. Has .NET type Double.
SQL_REAL	Single precision floating point number. Has .NET type Single.
SQL_DOUBLE	Double precision floating point number. Has .NET type Double.
SQL_DATE	A date. Has .NET type DateTime.
SQL_DATETIME	A date and time. Has .NET type DateTime.
SQL_TIME	A time. Has .NET type DateTime
SQL_INTERVAL	An interval of time. Has .NET type TimeSpan
SQL_TIMESTAMP	A time stamp. Has .NET type DateTime.
SQL_VARCHAR	A null terminated UTF-8 string with a user set maximum length. Has .NET type String.
SQL_TYPE_DATE	A date. Has .NET type DateTime.
SQL_TYPE_TIME	A time. Has .NET type DateTime.
SQL_TYPE_TIMESTAMP	A timestamp. Has .NET type DateTime
SQL_DEFAULT	A default type. Has no type.
SQL_ARD_TYPE	An ARD object. Has no type.
SQL_BIT	A single bit. Has .NET type Boolean.
SQL_TINYINT	8-bit integer. Has .NET type SByte.
SQL_BIGINT	64-bit integer. Has .NET type Int64.
SQL_LONGVARBINARY	Variable length binary data with a driver dependent maximum length. Has .NET type byte[].
SQL_VARBINARY	Variable length binary data with a user specified maximum length. Has .NET type byte[].
SQL_BINARY	Fixed length binary data. Has .NET type byte[].
SQL_LONGVARCHAR	A null terminated UTF-8 string with a driver dependent maximum length. Has .NET type String.
SQL_GUID	A GUID. Has .NET type Guid.
SQL_WCHAR	Unicode character array of fixed size. Has .NET type String.
SQL_WVARCHAR	Null terminated Unicode string of user defined maximum length; Has .NET type String.
SQL_WLONGVARCHAR	Null terminated Unicode string of driver dependent maximum length; Has .NET type String.
SQL_SS_TIMESTAMPOFFSET	Timestamp with time zone offset; Has .NET type iAnywhere.MobiLink.Script.DateTimeWithTimeZone This can be used only against Microsoft SQL Server and Oracle databases.

Each SQLType corresponds to a .NET type.

SQLType enumeration

Visual Basic syntax

C# syntax

Members

Remarks