MySQL Data Type Conversions

D toc

D s ed

r	true
editions	gdpent,gdppro,gdppr,awsent,awspro,awspr

Excerpt

This section covers data type conversions between the

D s webapp

r	true

and MySQL databases.

Info

NOTE: The

D s item

item	data types
r	true

listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data Type

Supported?

D s item

item	Data Type

array

N

bigint

Y

Integer

tinyint

Y

Integer

mediumint

Y

Integer

smallint

Y

Integer

int

Y

Integer

bit [ (n) ]

Y

String

float

Y

Float

numeric

Y

Float

decimal

Y

Decimal

real

Y

Float

boolean

Y

Bool

character varying(n), varchar(n)

Y

String

character(n), char(n)

Y

String

date

Y

Date

double

Y

Decimal

enum

N

set

N

json

Y

String

text

Y

String

tinytext

Y

String

mediumtext

Y

String

lontext

Y

String

time

Y

Datetime

datetime

Y

Datetime

timestamp

Y

Datetime

year

Y

String

Write/Publish

D s item

item	Data Type

PostgreSQL Column Type

Notes

Bool

BIT

VARCHAR

TINYINT(1)

Integer

BIGINT

INT

SMALLINT

MEDIUMINT

TINYINT

VARCHAR

String

VARCHAR

TINYTEXT

TEXT

MEDIUMTEXT

LONGTEXT

Datetime

TIMESTAMP

DATETIME

DATE

VARCHAR

Timestamp

VARCHAR

Float

FLOAT

DECIMAL

REAL

NUMERIC

VARCHAR

Map

VARCHAR

Array

VARCHAR

Info

NOTE: If you are appending to an existing table where a column's

D s item

item	data type

is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.

D s also

label	mysql

Page tree

Versions Compared

Old Version 3

New Version 4

Key

Access/Read

Write/Publish