Data Type Mapping for Aurora MySQL
This section lists the mapping of data types for Aurora MySQL.
Aurora MySQL as Source
When Aurora MySQL is used as a source location, following is the mapping of data types in Aurora MySQL to the corresponding Fivetran HVR repository data type.
| Aurora 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>> |
Aurora MySQL as Target
When Aurora MySQL is used as a target location, following is the mapping of HVR repository data types to the corresponding data type in Aurora MySQL.
Text in green cell indicates the native data type of the DBMS
| Repository Data Type | Attributes | Aurora 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 |
| binary decimal |
prec=9
scale=3 nullable=0 | decimal(9,3) |
| binary decimal |
prec=6
scale=2 nullable=0 | decimal(6,2) |
| 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 |
| datalink |
bytelen=800
charlen=200 encoding=UTF-8 nullable=0 | varchar(200) 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 rowid |
bytelen=40
nullable=0 | varchar(80) charset ascii |
| 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 |
| hierarchyid |
bytelen=892
nullable=0 | varchar(4000) charset ascii |
| 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 |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| jsonb |
encoding=UTF-8
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 time |
timeprec=6
nullable=0 | time(6) |
| 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 (databricks) |
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 |
| variant |
encoding=UTF-8
nullable=0 | longtext charset utf8mb4 |
| xml | nullable=0 | longtext charset utf16 |
| year (mysql) | nullable=0 | year |