AF type mapping

AnsiString

Maximum of 2GB.

Further limitations will apply on the client side driver.

Boolean

DateTime

Maps to Filetime internally with 100 ns precision.

Double

Guid

Int8

Int16

Int32

Int64

Single

String

Maximum of 2GB.

Further limitations will apply on the client side driver.

TimePeriod

String literals are defined in AF. For example, '1d' and 't.'

String literals can be localized. For example, N'1T' and N'H.'

TimeSpan

Maps to long integer internally with 100 ns precision.

UInt8

UInt16

UInt32

UInt64

Variant

complex types, such as file and array, are not supported. Instead, NULL is returned.