Enumerates all possible ODBC data types.
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.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |