Striim 3.9.7 documentation

MySQLReader data type support and correspondence

MySQL type

TQL type

comments

BIGINT

long

BIGINT UNSIGNED

long

Values greater than the midpoint of the range (9223372036854775807) are represented as negative values (the high bit is on, interpreting the value as negative).

BINARY

string

BIT

unsupported

BLOB

string

CHAR

string

DATE

org.joda.time.LocalDate

If the MySQL and Striim hosts are not in the same time zone, the value will be converted to Striim's time zone.

DATETIME

org.joda.time.DateTime

Fractional seconds, if used, are dropped. If the MySQL and Striim hosts are not in the same time zone, the value will be converted to Striim's time zone.

DECIMAL

string

DECIMAL UNSIGNED

string

DOUBLE

double

ENUM

int

The value is the integer that is MySQL's internal representation (enumeration literals are assigned numbers in the order the literals were written in the declaration).

FLOAT

float

If replicating from one MySQL database to another, see the notes for the Compression property in MySQLReader and MariaDBReader properties.

geometry types

unsupported

INT

int

INT UNSIGNED

int

Values greater than the midpoint of the range (4294967295) are represented as negative values (the high bit is on, interpreting the value as negative).

JSON

JSONNode

LONGBLOB

string

LONGTEXT

string

MEDIUMBLOB

string

MEDIUMINT

int

MEDIUMINT UNSIGNED

int

Values greater than the midpoint of the range (8388607) are represented as negative values (the high bit is on, interpreting the value as negative).

MEDIUMTEXT

string

NUMERIC

string

NUMERIC UNSIGNED

string

SET

long

The value is the integer that is MySQL's internal representation (the integer represented by the bit string in which the nth bit is set, if the nth member of the SET's literals is present in the set).

SMALLINT

short

SMALLINT UNSIGNED

short

Values greater than the midpoint of the range (32767) are represented as negative values (the high bit is on, interpreting the value as negative).

spatial types

unsupported

TEXT

string

TIME

org.joda.time.LocalTime

Fractional seconds, if used, are dropped. If the MySQL and Striim hosts are not in the same time zone, the value will be converted to Striim's time zone.

TIMESTAMP

org.joda.time.DateTime

Fractional seconds, if used, are dropped. If the MySQL and Striim hosts are not in the same time zone, the value will be converted to Striim's time zone.

TINYBLOB

string

TINYINT

byte

TINYINT UNSIGNED

byte

Values greater than the midpoint of the range (127) are represented as negative values (the high bit is on, interpreting the value as negative).

TINYTEXT

string

VARBINARY

string

VARCHAR

string

YEAR

int