Data Type Mapping for MySQL
This section lists the mapping of data types for MySQL.
MySQL as Source
When MySQL is used as a source location, following is the mapping of data types in MySQL to the corresponding Local Data Processing repository data type.
| MySQL | Capture Support | Repository Data Type |
|---|---|---|
| bigint | Native | bigint |
| bigint unsigned | Native | bigint unsigned |
| bit | Native | bit (mysql) |
| bool | Native | tinyint signed |
| boolean | Native | tinyint signed |
| dec | Native | decimal |
| dec unsigned | Native | decimal |
| decimal | Native | decimal |
| decimal unsigned | Native | decimal |
| double | Native | double |
| double precision | Native | double |
| double precision unsigned | Native | double |
| double unsigned | Native | double |
| fixed | Native | decimal |
| fixed unsigned | Native | decimal |
| float | Native | real |
| float unsigned | Native | real |
| int | Native | int |
| int unsigned | Native | int unsigned |
| integer | Native | int |
| integer unsigned | Native | int unsigned |
| mediumint | Native | mediumint |
| mediumint unsigned | Native | mediumint unsigned |
| numeric | Native | decimal |
| numeric unsigned | Native | decimal |
| real | Native | double |
| real unsigned | Native | double |
| smallint | Native | smallint |
| smallint unsigned | Native | smallint unsigned |
| tinyint | Native | tinyint signed |
| tinyint unsigned | Native | tinyint unsigned |
| date | Native | ansidate |
| datetime | Native | datetime (mysql) |
| time | Native | time (mysql) |
| timestamp | Native | timestamp (mysql) |
| year | Native | smallint |
| binary | Native | binary |
| blob | Native | varbinary(max) |
| char | Native | char |
| long varchar | Native | varchar(max) |
| longblob | Native | varbinary(max) |
| longtext | Native | varchar(max) |
| mediumblob | Native | varbinary(max) |
| mediumtext | Native | varchar(max) |
| long | Native | varchar(max) |
| text | Native | varchar(max) |
| tinyblob | Native | varbinary(max) |
| tinytext | Native | varchar(max) |
| varbinary | Native | varbinary |
| varchar | Native | varchar |
| enum | Extended | <<enum>> |
| set | Extended | <<set>> |
| geometry | Extended | <<geometry>> |
| geometrycollection | Extended | <<geometrycollection>> |
| linestring | Extended | <<linestring>> |
| multilinestring | Extended | <<multilinestring>> |
| multipoint | Extended | <<multipoint>> |
| multipolygon | Extended | <<multipolygon>> |
| point | Extended | <<point>> |
| polygon | Extended | <<polygon>> |
| json | Extended | <<json>> |
MySQL as Target
When MySQL is used as a target location, following is the mapping of Local Data Processing repository data types to the corresponding data type in MySQL.
Text in green cell indicates the native data type of the DBMS
| Repository Data Type | Attributes | MySQL (UTF-8) |
|---|---|---|
| ansidate (ingres) | nullable=0 | date |
| ansidate | nullable=0 | date |
| bfile | nullable=0 | longblob |
| bigdatetime |
timeprec=6
nullable=0 | datetime(6) |
| bigint unsigned |
bytelen=8
nullable=0 | bigint unsigned |
| bigint |
bytelen=8
nullable=0 | bigint |
| bigtime |
timeprec=6
nullable=0 | time(6) |
| binary |
bytelen=10
nullable=0 | binary(10) |
| binary_double |
bytelen=8
nullable=0 | double |
| binary_float |
bytelen=4
nullable=0 | float |
| bit (mysql) |
bitlen=32
nullable=0 | bit(32) |
| bit |
bytelen=1
nullable=0 | tinyint |
| blob | nullable=0 | longblob |
| bool |
bytelen=1
nullable=0 | tinyint |
| boolean |
bytelen=1
nullable=0 | tinyint |
| byte varying |
bytelen=10
nullable=0 | varbinary(10) |
| byte |
bytelen=10
nullable=0 | binary(10) |
| byteint |
bytelen=1
nullable=0 | tinyint |
| c |
bytelen=10
encoding=UTF-8 nullable=0 | char(10) charset utf8mb4 |
| char |
bytelen=10
encoding=UTF-8 nullable=0 | char(10) charset utf8mb4 |
| char |
bytelen=4000
encoding=UTF-8 nullable=0 | varchar(4000) charset utf8mb4 |
| char |
bytelen=8000
encoding=UTF-8 nullable=0 | varchar(8000) charset utf8mb4 |
| char |
bytelen=40
charlen=10 encoding=UTF-8 nullable=0 | char(10) charset utf8mb4 |
| char |
bytelen=10
encoding=WINDOWS-1252 nullable=0 | char(10) charset latin1 |
| char (oracle) |
bytelen=10
encoding=UTF-8 nullable=0 | char(10) charset utf8mb4 |
| char (oracle) |
bytelen=2000
encoding=UTF-8 nullable=0 | varchar(2000) charset utf8mb4 |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 nullable=0 | char(10) charset utf8mb4 |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 nullable=0 | char(10) charset latin1 |
| clob |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| date | nullable=0 | datetime(0) |
| date (hana) | nullable=0 | date |
| date (mysql) | nullable=0 | date |
| date (sybase) | nullable=0 | date |
| datetime (bigquery) |
timeprec=0
nullable=0 | datetime(0) |
| datetime (mysql) |
timeprec=0
nullable=0 | datetime(0) |
| datetime (sybase) | nullable=0 | datetime(3) |
| datetime | nullable=0 | datetime(3) |
| datetime2 |
timeprec=0
nullable=0 | datetime(0) |
| datetimeoffset |
timeprec=0
nullable=0 | datetime(0) |
| db2 timestamp with time zone |
timeprec=0
nullable=0 | datetime(0) |
| db2 xml |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| dbclob | nullable=0 | longtext charset utf16 |
| decfloat |
prec=16
nullable=0 | varchar(42) charset utf8mb4 |
| decfloat |
prec=34
nullable=0 | varchar(42) charset utf8mb4 |
| decimal |
prec=10
scale=3 nullable=0 | decimal(10,3) |
| decimal |
prec=6
nullable=0 | decimal(6) |
| double |
bytelen=8
nullable=0 | double |
| epoch |
timeprec=0
nullable=0 | timestamp(0) |
| float |
bytelen=8
nullable=0 | double |
| float4 |
bytelen=4
nullable=0 | float |
| float8 |
bytelen=8
nullable=0 | double |
| float64 |
bytelen=8
nullable=0 | double |
| graphic |
charlen=10
nullable=0 | char(10) charset utf16 |
| image | nullable=0 | longblob |
| image (sybase) | nullable=0 | longblob |
| ingresdate | nullable=0 | datetime(0) |
| int unsigned |
bytelen=4
nullable=0 | int unsigned |
| int |
bytelen=4
nullable=0 | int |
| integer |
bytelen=4
nullable=0 | int |
| integer1 |
bytelen=1
nullable=0 | tinyint |
| integer2 |
bytelen=2
nullable=0 | smallint |
| integer4 |
bytelen=4
nullable=0 | int |
| integer8 |
bytelen=8
nullable=0 | bigint |
| int64 |
bytelen=8
nullable=0 | bigint |
| interval day to second (ingres) |
timeprec=0
nullable=0 | datetime(0) |
| interval day to second |
timeprec=0
dayprec=0 nullable=0 | datetime(0) |
| interval month to second |
timeprec=0
nullable=0 | datetime(0) |
| interval year to month (ingres) | nullable=0 | datetime(0) |
| interval year to month |
yearprec=0
nullable=0 | datetime(0) |
| json | nullable=0 | longtext charset utf8mb4 |
| jsonb | nullable=0 | longtext charset utf8mb4 |
| long byte | nullable=0 | longblob |
| long char |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| long nvarchar (db2) | nullable=0 | longtext charset utf16 |
| long nvarchar | nullable=0 | longtext charset utf16 |
| long raw | nullable=0 | longblob |
| long varbinary | nullable=0 | longblob |
| long varchar (db2) |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| long varchar |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| long |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| mediumint unsigned |
bytelen=3
nullable=0 | mediumint unsigned |
| mediumint |
bytelen=3
nullable=0 | mediumint |
| money (ingres) | nullable=0 | decimal(14,2) |
| money | nullable=0 | decimal(19,4) |
| nchar |
charlen=10
nullable=0 | char(10) charset utf16 |
| nchar (oracle) |
bytelen=20
charlen=10 nullable=0 | char(10) charset utf16 |
| nclob | nullable=0 | longtext charset utf16 |
| ntext | nullable=0 | longtext charset utf16 |
| number | nullable=0 | decimal(65,4) |
| number |
prec=10
scale=-127 nullable=0 | double |
| number |
prec=10
scale=3 nullable=0 | decimal(10,3) |
| number |
prec=26
nullable=0 | decimal(26) |
| number |
prec=6
nullable=0 | int |
| numeric (db2i) |
prec=10
scale=3 nullable=0 | decimal(10,3) |
| numeric (db2i) |
prec=6
nullable=0 | decimal(6) |
| numeric |
prec=10
scale=3 nullable=0 | decimal(10,3) |
| numeric |
prec=26
nullable=0 | decimal(26) |
| numeric |
prec=6
nullable=0 | decimal(6) |
| nvarchar |
charlen=10
nullable=0 | varchar(10) charset utf16 |
| nvarchar(max) | nullable=0 | longtext charset utf16 |
| nvarchar2 |
charlen=10
nullable=0 | varchar(10) charset utf16 |
| postgres date | nullable=0 | date |
| postgres timestamp with time zone |
timeprec=0
nullable=0 | datetime(0) |
| postgres timestamp |
timeprec=0
nullable=0 | datetime(0) |
| raw |
bytelen=10
nullable=0 | varbinary(10) |
| real |
bytelen=4
nullable=0 | float |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII nullable=0 | char(18) charset ascii |
| rowversion |
bytelen=10
nullable=0 | binary(10) |
| smalldatetime | nullable=0 | datetime(0) |
| smallint unsigned |
bytelen=2
nullable=0 | smallint unsigned |
| smallint |
bytelen=2
nullable=0 | smallint |
| smallmoney | nullable=0 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| text (sqlserver) |
encoding=WINDOWS-1252
nullable=0 | longtext charset latin1 |
| text(sybase) |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| time (mysql) |
timeprec=0
nullable=0 | time(0) |
| time (hana) | nullable=0 | time(0) |
| time (sybase) | nullable=0 | time(3) |
| time with local time zone |
timeprec=0
nullable=0 | time(0) |
| time with time zone |
timeprec=0
nullable=0 | time(0) |
| time |
timeprec=0
nullable=0 | time(0) |
| time |
timeprec=3
nullable=0 | time(3) |
| time2 | nullable=0 | time(0) |
| timestamp (bigquery) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp (db2) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp (hana) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp (ingres) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp (mysql) |
timeprec=0
nullable=0 | timestamp(0) |
| timestamp (oracle) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp (sqlserver) |
bytelen=10
nullable=0 | binary(10) |
| timestamp (sybase) |
bytelen=10
nullable=0 | varbinary(10) |
| timestamp with local time zone |
timeprec=0
nullable=0 | datetime(0) |
| timestamp with local tz (oracle) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp with time zone |
timeprec=0
nullable=0 | datetime(0) |
| timestamp with tz (oracle) |
timeprec=0
nullable=0 | datetime(0) |
| timestamp |
timeprec=0
nullable=0 | datetime(0) |
| tinyint signed |
bytelen=1
nullable=0 | tinyint |
| tinyint unsigned |
bytelen=1
nullable=0 | tinyint unsigned |
| tinyint |
bytelen=1
nullable=0 | tinyint unsigned |
| uniqueidentifier |
bytelen=16
nullable=0 | binary(16) |
| unitext | nullable=0 | longtext charset utf16 |
| univarchar |
charlen=10
nullable=0 | varchar(10) charset utf16 |
| unsigned bigint |
bytelen=8
nullable=0 | bigint unsigned |
| unsigned int |
bytelen=4
nullable=0 | int unsigned |
| unsigned smallint |
bytelen=2
nullable=0 | smallint unsigned |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII nullable=0 | varchar(100) charset ascii |
| varbinary |
bytelen=10
nullable=0 | varbinary(10) |
| varbinary (sybase) |
bytelen=10
nullable=0 | varbinary(10) |
| varbinary(max) | nullable=0 | longblob |
| varbyte |
bytelen=10
nullable=0 | varbinary(10) |
| varchar |
bytelen=10
encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| varchar |
bytelen=8000
encoding=UTF-8 nullable=0 | varchar(8000) charset utf8mb4 |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| varchar |
bytelen=10
encoding=WINDOWS-1252 nullable=0 | varchar(10) charset latin1 |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 nullable=0 | varchar(8000) charset utf8mb4 |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 nullable=0 | varchar(10) charset latin1 |
| varchar(max) |
encoding=WINDOWS-1252
nullable=0 | longtext charset latin1 |
| varchar2 |
bytelen=10
encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 nullable=0 | varchar(10) charset utf8mb4 |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 nullable=0 | varchar(10) charset latin1 |
| vargraphic |
charlen=10
nullable=0 | varchar(10) charset utf16 |
| xml | nullable=0 | longtext charset utf16 |
| year (mysql) | nullable=0 | year |
Comments
0 comments
Please sign in to leave a comment.