Striim 4.0.4 documentation

... for MySQL sources

MySQL source type

BigQuery

MySQL

Oracle

PostgreSQL

Snowflake

Spanner

SQL Server / Azure Synapse

bigint / bigint unsigned

int64 / numeric

bigint / bigint unsigned

int

bigInt / double precision

integer

int64 / float64

bigInt / numeric(38)

binary

bytes

binary(s)

blob

bytea

binary

bytes

binary(s)

bit / bit(s)

not supported

bit / bit(s)

not supported

bit / bit varying(s)

binary

not supported

bit

blob

bytes

longblob

blob

bytea

binary

bytes(65535)

bytes(max)

varbinary(p) if <= 8000

varbinary(max) if > 8000

char(s)

string

character(s) if s<255

longtext if s>255

character(s) if s<=2000

clob if s>2000

character(s)

character(s)

string(s)

character(s) if s<=8000

varchar(max) if s>8000

date

date

date

date

date

date

date

date

datetime

datetime

datetime

timestamp

timestamp without time zone

datetime

timestamp

datetime2

decimal

numeric

decimal(10,0)

number(10,0)

numeric(10,0)

numeric(10,0)

float64

numeric(10,0)

decimal(p,s)

numeric if p<=38 and s<=8

string if p>38 or s>9

decimal(p,s) if p<=65 and s<=30

text if p>65 or s>30

number(p,s) if p<=38 and s<=127

varchar2(1000) if p>38 or s>127

numeric(p,s)

numeric(p,s) if p<=38 snf s<=37

varchar if p>38 or s>37

float64 if p<=308 and s<=15

string(max) if p>308 pr s>15

decimal(p,s) if p<=38 and s<=38

varchar(8000) if p>38 or s>38

decimal(p)

numeric if p<=38

string if p>38

decimal(p) if p<=65

text if p>65

number(p) if p<=38

varchar2(1000) if p>38

numeric(p)

numeric(p) if p<=38

varchar if p>38

float64 if p<=308

string(max) if p>308

decimal(p) if p<=38

varchar(8000) if p>38

double

float64

double

double precision

double precision

double precision

float64

double precision

double(p,s)

float64

double

double precision

double precision

double precision

float64 if p<=308 and s<=15

string(max) if p>308 or s>15

float

enum

not supported

not supported

not supported

not supported

varchar

not supported

not supported

float

float64

decimal

float

double precision

float

float64

float

float(p,s)

float64

float(p) if p<=38

double if p>38

float(p)

double precision

float(p) if p<=38

float if p>38

float64

float(p) if p<=53

varchar(8000) if p>53

int / int unsigned

int64

int / int unsigned

int

bigInt

integer

int64

integer

json

string

json

clob

json

variant

string(max)

varchar if <= 8000

varchar(max) > 8000

longblob

bytes

longblob

blob

bytea

binary

bytes(max)

varbinary(p) if <= 8000

varbinary(max) for > 8000

longtext

string

tinytext / longtext

clob

text

varchar

string(max)

character(s) if s<=8000

varchar(max) if s>8000

mediumblob

bytes

longblob

blob

bytea

binary

bytes(max)

varbinary(p) if <= 8000

varbinary(max) for > 8000

mediumInt / mediumInt unsigned

int64

mediumInt / mediumInt unsigned

int

integer

integer

int64

integer

mediumtext

string

tinytext / longtext

clob

text

varchar

string(max)

character(s) if s<=8000

varchar(max) if s>8000

smallint / smallint unsigned

int64

smallint / smallint unsigned

int

smallint

integer

int64

smallint

text

string

text

clob

text

varchar

string(s)

varchar if s<=8000

varchar(max) if s>8000

time

time

time

varchar2(200)

time

time

string(max)

time

timestamp

timestamp

timestamp

timestamp with time zone

timestamp without time zone

timestamp with timezone

timestamp

datetimeOffset

tinyblob

bytes

longblob

blob

bytea

binary

bytes(255)

bytes(max)

varbinary(p) if <= 8000

varbinary(max) for > 8000

tinyint / tinyint unsigned

int64

tinyint / tinyint unsigned

int

smallint

integer

int64

tinyInt

tinyint(1)

boolean

tinyint(1)

not supported

boolean

boolean

bool

not supported

tinytext

string

tinytext

clob

text

varchar

string(s)

character(s) if s<=8000

varchar(max) if s>8000

varbinary(s)

bytes

varbinary(s)

blob

character varying(s)

varbinary

bytes(s)

varbinary(s) if s<=8000

varbinary(max) if s>8000

varchar(s)

string

varchar(s)

varchar2(s) if s<=4000

clob if s>4000

character varying(s)

varchar(s)

string(s)

varchar(s) if s<=8000

varchar(max) if s>8000

year

not supported

not supported

not supported

not supported

numeric(38,0)

not supported

not supported

MySQL spatial types are not supported.

See Using Data Types from Other Database Engines for a list of supported data type aliases (such as boolean and numeric).