MobiLink Synchronization User's Guide
  Writing Synchronization Scripts in .NET
    MobiLink .NET API Reference

SQLType enumeration

public enum SQLType
Member of iAnywhere.MobiLink.Script

Enumeration of all possible ODBC data types.

SQL_TYPE_NULL field 

public SQL_TYPE_NULL

Null data type.

SQL_UNKNOWN_TYPE field 

public SQL_UNKNOWN_TYPE

Unknown data type.

SQL_CHAR field 

public SQL_CHAR

UTF-8 character array of a set size. Has .NET type String.

SQL_NUMERIC field 

public SQL_NUMERIC

Numeric value of set size and precision. Has .NET type Decimal.

SQL_DECIMAL field 

public SQL_DECIMAL

Decimal number of set size and precision. Has .NET type Decimal.

SQL_INTEGER field 

public SQL_INTEGER

32-bit integer. Has .NET type Int32.

SQL_SMALLINT field 

public SQL_SMALLINT

16-bit integer. Has .NET type Int16.

SQL_FLOAT field 

public SQL_FLOAT

Floating point number with ODBC driver defined precision. Has .NET type Double.

SQL_REAL field 

public SQL_REAL

Single precision floating-point number. Has .NET type Single.

SQL_DOUBLE field 

public SQL_DOUBLE

Double precision floating point number. Has .NET type Double.

SQL_DATE field 

public SQL_DATE

A date. Has .NET type DateTime.

SQL_DATETIME field 

public SQL_DATETIME

A date and time. Has .NET type DateTime.

SQL_TIME field 

public SQL_TIME

A time. Has .NET type DateTime.

SQL_INTERVAL field 

public SQL_INTERVAL

An interval of time. Has .NET type TimeSpan.

SQL_TIMESTAMP field 

public SQL_TIMESTAMP

A time stamp. Has .NET type DateTime.

SQL_VARCHAR field 

public SQL_VARCHAR

A null terminated UTF-8 string with a user set maximum length. Has .NET type String.

SQL_TYPE_DATE field 

public SQL_TYPE_DATE

A date. Has .NET type DateTime.

SQL_TYPE_TIME field 

public SQL_TYPE_TIME

A time. Has .NET type DateTime.

SQL_TYPE_TIMESTAMP field 

public SQL_TYPE_TIMESTAMP

A timestamp. Has .NET type DateTime.

SQL_DEFAULT field 

public SQL_DEFAULT

A default type. Has no type.

SQL_ARD_TYPE field 

public SQL_ARD_TYPE

An ARD object. Has no type.

SQL_BIT field 

public SQL_BIT

A single bit. Has .NET type Boolean.

SQL_TINYINT field 

public SQL_TINYINT

An 8-bit integer. Has .NET type SByte.

SQL_BIGINT field 

public SQL_BIGINT

A 64-bit integer. Has .NET type Int64.

SQL_LONGVARBINARY field 

public SQL_LONGVARBINARY

Variable length binary data with a driver dependent maximum length. Has .NET type byte[ ].

SQL_VARBINARY field 

public SQL_VARBINARY

Variable length binary data with a user specified maximum length. Has .NET type byte[ ].

SQL_BINARY field 

public SQL_BINARY

Fixed length binary data. Has .NET type byte[ ].

SQL_LONGVARCHAR field 

public SQL_LONGVARCHAR

A null-terminated UTF-8 string with a driver-dependent maximum length. Has .NET type String.

SQL_GUID field 

public SQL_GUID

A Global Unique ID (also called a UUID). Has .NET type Guid.

SQL_WCHAR field 

public SQL_WCHAR

Unicode character array of fixed size. Has .NET type String.

SQL_WVARCHAR field 

public SQL_WVARCHAR

Null-terminated Unicode string of user-defined maximum length. Has .NET type String.

SQL_WLONGVARCHAR field 

public SQL_WLONGVARCHAR

Null-terminated Unicode string of driver-dependent maximum length. Has .NET type String.