SQLPreparedStatementMBS.kTypeBlob = 16

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

Binary large Object. Pass a string or memoryblock.

SQLPreparedStatementMBS.kTypeBool = 1

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

Boolean

SQLPreparedStatementMBS.kTypeBytes = 13

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

a binary string or MemoryBlock.
(which is a string without text encoding)

This is usually a varbinary field. kTypeLongBinary is used for bigger binary data and streamed. And kTypeBlob is used for huge streams of bytes and also transferred in chunks. In most data base systems the varchar field is stored within the record, while BLOB and CLOB are stored separately.

SQLPreparedStatementMBS.kTypeClob = 17

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

Character Large Object.

SQLPreparedStatementMBS.kTypeDateTime = 10

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

Date and/or Time.

SQLPreparedStatementMBS.kTypeDouble = 8

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

double float value.

SQLPreparedStatementMBS.kTypeInt32 = 4

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	20.2

One of the data type constants.

signed 32 bit integer

SQLPreparedStatementMBS.kTypeInt64 = 6

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	19.5

One of the data type constants.

Signed 64-bit integer.

SQLPreparedStatementMBS.kTypeInterval = 11

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	13.5

One of the data type constants.

An interval.
Please pass SQLIntervalMBS in the variant. If the variant contains anything else, the plugin will pass nil value.

When passing variant for value, MemoryBlock and Strings without text encoding are converted to byte values (BLOB). Texts and Strings with encoding are converted to text values. Other types are translated as good as possible. Raises exceptions if you pass anything which is not recognized.

SQLPreparedStatementMBS.kTypeLong = 4

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

signed 32 bit integer

SQLPreparedStatementMBS.kTypeLongBinary = 14

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

Long binary.

SQLPreparedStatementMBS.kTypeLongChar = 15

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

Long string.

SQLPreparedStatementMBS.kTypeNull = 99

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	14.3

One of the data type constants.

NULL value

SQLPreparedStatementMBS.kTypeNumeric = 9

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	13.5

One of the data type constants.

A number (Int64 or double).
This can be used for Int64 or Double values. Depending of the type of number in the variant, the plugin will either make an Int64 or a double internally.

When passing variant for value, MemoryBlock and Strings without text encoding are converted to byte values (BLOB). Texts and Strings with encoding are converted to text values. Other types are translated as good as possible. Raises exceptions if you pass anything which is not recognized.

SQLPreparedStatementMBS.kTypeShort = 2

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

signed 16 bit integer

SQLPreparedStatementMBS.kTypeString = 12

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

String.
This is usually a varchar field. kTypeLongChar is used for bigger varchars and streamed. And kTypeClob is used for huge streams of characters (BLOB for text) and also transferred in chunks. In most data base systems the varchar field is stored within the record, while BLOB and CLOB are stored separately.

SQLPreparedStatementMBS.kTypeUInt32 = 5

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	20.2

One of the data type constants.

unsigned 32 bit integer

SQLPreparedStatementMBS.kTypeUInt64 = 7

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	19.5

One of the data type constants.

Unsigned 64-bit integer.

SQLPreparedStatementMBS.kTypeULong = 5

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

unsigned 32 bit integer

SQLPreparedStatementMBS.kTypeUnknown = 0

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

unknown type

SQLPreparedStatementMBS.kTypeUShort = 3

Type	Topic	Plugin	Version
const	SQL	MBS SQL Plugin	11.2

One of the data type constants.

unsigned 16 bit integer