This documentation is for an older version of HVR.
Data Type Mapping for Ingres
This section lists the mapping of data types for Ingres.
Ingres as Source
When Ingres is used as a source location, following is the mapping of data types in Ingres to the corresponding HVR repository data type.
| Ingres | HVR Capture Support | HVR Repository Data Type |
|---|---|---|
| bigint | Native | integer8 |
| decimal | Native | decimal |
| float | Native | float8 |
| float4 | Native | float4 |
| float8 | Native | float8 |
| integer | Native | integer4 |
| integer1 | Native | integer1 |
| integer2 | Native | integer2 |
| integer4 | Native | integer4 |
| integer8 | Native | integer8 |
| real | Native | float4 |
| smallint | Native | integer2 |
| tinyint | Native | integer1 |
| ansidate | Native | ansidate |
| ingresdate | Native | ingresdate |
| interval day to second | Native | interval day to second (ingres) |
| interval year to month | Native | interval year to month (ingres) |
| time with local time zone | Native | time with local time zone |
| time with time zone | Native | time with time zone |
| time without time zone | Native | time |
| timestamp with local timezone | Native | timestamp with local timezone |
| timestamp with time zone | Native | timestamp with time zone |
| timestamp without time zone | Native | timestamp (ingres) |
| c | Native | c |
| char | Native | char |
| clob | Native | long varchar |
| long nvarchar | Native | long nvarchar |
| long varchar | Native | long varchar |
| nchar | Native | nchar |
| nclob | Native | long nvarchar |
| nvarchar | Native | nvarchar |
| text | Native | text (ingres) |
| varchar | Native | varchar |
| ipv4 | Extended | <<ipv4>> |
| ipv6 | Extended | <<ipv6>> |
| logical_key | Extended | <<logical_key>> |
| money | Native | money (ingres) |
| uuid | Extended | <<uuid>> |
| byte | Native | byte |
| byte varying / varbyte | Native | byte varying |
| long byte | Native | long byte |
| boolean | Native | boolean |
| circularstring | Extended | <<circularstring>> |
| compoundcurve | Extended | <<compoundcurve>> |
| curvepolygon | Extended | <<curvepolygon>> |
| geometry | Extended | <<geometry>> |
| geometrycollection | Extended | <<geometrycollection>> |
| linestring | Extended | <<linestring>> |
| multicurve | Extended | <<multicurve>> |
| multilinestring | Extended | <<multilinestring>> |
| multipoint | Extended | <<multipoint>> |
| multipolygon | Extended | <<multipolygon>> |
| multisurface | Extended | <<multisurface>> |
| point | Extended | <<point>> |
| polygon | Extended | <<polygon>> |
| polyhedralsurface | Extended | <<polyhedralsurface>> |
| tin | Extended | <<tin>> |
| triangle | Extended | <<triangle>> |
Ingres as Target
When Ingres is used as a target location, following is the mapping of HVR repository data types to the corresponding data type in Ingres.
Text in green cell indicates the native data type of the DBMS
| HVR Repository Data Types | Attributes | Ingres (UTF-8) |
|---|---|---|
| ansidate (ingres) | null=1 | ansidate |
| ansidate | null=1 | ansidate |
| bfile | null=1 | long byte |
| bigint unsigned |
bytelen=8
null=1 | decimal(20) |
| bigint |
bytelen=8
null=1 | bigint |
| binary |
bytelen=10
null=1 | byte(10) |
| binary_double |
bytelen=8
null=1 | float |
| binary_float |
bytelen=4
null=1 | float4 |
| bit (mysql) |
bitlen=32
null=1 | varchar(32) |
| bit |
bytelen=1
null=1 | boolean |
| blob | null=1 | long byte |
| bool |
bytelen=1
null=1 | boolean |
| boolean |
bytelen=1
null=1 | boolean |
| byte varying |
bytelen=10
null=1 | byte varying(10) |
| byte |
bytelen=10
null=1 | byte(10) |
| byteint |
bytelen=1
null=1 | i1 |
| c |
bytelen=10
encoding=UTF-8 null=1 | c10 |
| char |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char |
bytelen=4000
encoding=UTF-8 null=1 | char(4000) |
| char |
bytelen=8000
encoding=UTF-8 null=1 | char(8000) |
| char |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(40) |
| char |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(20) |
| char (oracle) |
bytelen=10
encoding=UTF-8 null=1 | char(10) |
| char (oracle) |
bytelen=2000
encoding=UTF-8 null=1 | char(2000) |
| char (oracle) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | char(40) |
| char (oracle) |
bytelen=10
encoding=WINDOWS-1252 null=1 | char(20) |
| clob |
encoding=UTF-8
null=1 | long varchar |
| date | null=1 | ingresdate |
| date (hana) | null=1 | ansidate |
| date (mysql) | null=1 | ansidate |
| date (sybase) | null=1 | ansidate |
| datetime (bigquery) |
prec_sec=0
null=1 | timestamp(0) without time zone |
| datetime (mysql) |
prec_sec=0
null=1 | timestamp(0) without time zone |
| datetime (sybase) | null=1 | ingresdate |
| datetime | null=1 | ingresdate |
| datetime2 |
prec_sec=0
null=1 | timestamp(0) without time zone |
| datetimeoffset |
prec_sec=0
null=1 | timestamp(0) with time zone |
| db2 timestamp with time zone |
prec_sec=0
null=1 | timestamp(0) with time zone |
| db2 xml |
encoding=UTF-8
null=1 | long varchar |
| dbclob |
charlen=0
null=1 | long nvarchar |
| decfloat |
prec=16
null=1 | varchar(42) |
| decfloat |
prec=34
null=1 | varchar(42) |
| decimal |
prec=10
scale=3 null=1 | decimal(10,3) |
| decimal |
prec=6
null=1 | decimal(6) |
| double |
bytelen=8
null=1 | float |
| epoch |
prec_sec=0
null=1 | timestamp(0) with local time zone |
| float |
bytelen=8
null=1 | float |
| float4 |
bytelen=4
null=1 | float4 |
| float8 |
bytelen=8
null=1 | float |
| float64 |
bytelen=8
null=1 | float |
| graphic |
charlen=10
null=1 | nchar(10) |
| image | null=1 | long byte |
| image (sybase) | null=1 | long byte |
| ingresdate | null=1 | ingresdate |
| int unsigned |
bytelen=4
null=1 | bigint |
| int |
bytelen=4
null=1 | integer |
| integer |
bytelen=4
null=1 | integer |
| integer1 |
bytelen=1
null=1 | i1 |
| integer2 |
bytelen=2
null=1 | smallint |
| integer4 |
bytelen=4
null=1 | integer |
| integer8 |
bytelen=8
null=1 | bigint |
| int64 |
bytelen=8
null=1 | bigint |
| interval day to second (ingres) |
prec_sec=0
null=1 | interval day to second(0) |
| interval day to second |
prec_sec=0
prec_day=0 null=1 | interval day to second(0) |
| interval month to second |
prec_sec=0
null=1 | interval day to second(0) |
| interval year to month (ingres) | null=1 | interval year to month |
| interval year to month |
prec_year=0
null=1 | interval year to month |
| json | null=1 | long varchar |
| jsonb | null=1 | long varchar |
| long byte | null=1 | long byte |
| long char |
encoding=UTF-8
null=1 | long varchar |
| long nvarchar (db2) |
charlen=0
null=1 | long nvarchar |
| long nvarchar |
charlen=0
null=1 | long nvarchar |
| long raw | null=1 | long byte |
| long varbinary | null=1 | long byte |
| long varchar (db2) |
encoding=UTF-8
null=1 | long varchar |
| long varchar |
encoding=UTF-8
null=1 | long varchar |
| long |
encoding=UTF-8
null=1 | long varchar |
| mediumint unsigned |
bytelen=3
null=1 | integer |
| mediumint |
bytelen=3
null=1 | integer |
| money (ingres) | null=1 | money |
| money | null=1 | money |
| nchar |
charlen=10
null=1 | nchar(10) |
| nchar (oracle) |
bytelen=20
charlen=10 null=1 | nchar(10) |
| nclob |
charlen=0
null=1 | long nvarchar |
| ntext |
charlen=0
null=1 | long nvarchar |
| number |
scale=0
null=1 | decimal(39,4) |
| number |
prec=10
scale=-127 null=1 | float |
| number |
prec=10
scale=3 null=1 | decimal(10,3) |
| number |
prec=26
scale=0 null=1 | decimal(26) |
| number |
prec=6
scale=0 null=1 | integer |
| numeric (db2i) |
prec=10
scale=3 null=1 | decimal(10,3) |
| numeric (db2i) |
prec=6
null=1 | decimal(6) |
| numeric |
prec=10
scale=3 null=1 | decimal(10,3) |
| numeric |
prec=26
null=1 | decimal(26) |
| numeric |
prec=6
null=1 | decimal(6) |
| nvarchar |
charlen=10
null=1 | nvarchar(10) |
| nvarchar(max) |
charlen=0
null=1 | long nvarchar |
| nvarchar2 |
charlen=10
null=1 | nvarchar(10) |
| postgres date | null=1 | ansidate |
| postgres timestamp with time zone |
prec_sec=0
null=1 | timestamp(0) with time zone |
| postgres timestamp |
prec_sec=0
null=1 | timestamp(0) without time zone |
| raw |
bytelen=10
null=1 | byte varying(10) |
| real |
bytelen=4
null=1 | float4 |
| rowid |
bytelen=18
charlen=18 encoding=US-ASCII null=1 | char(18) |
| rowversion |
bytelen=10
null=1 | byte(10) |
| smalldatetime | null=1 | ingresdate |
| smallint unsigned |
bytelen=2
null=1 | integer |
| smallint |
bytelen=2
null=1 | smallint |
| smallmoney | null=1 | decimal(10,4) |
| text (ingres) |
bytelen=10
encoding=UTF-8 null=1 | text(10) |
| text (sqlserver) |
encoding=WINDOWS-1252
null=1 | long varchar |
| text(sybase) |
encoding=UTF-8
null=1 | long varchar |
| time (mysql) |
prec_sec=0
null=1 | time(0) without time zone |
| time (hana) | null=1 | time(0) without time zone |
| time (sybase) | null=1 | time(3) without time zone |
| time with local time zone |
prec_sec=0
null=1 | time(0) with local time zone |
| time with time zone |
prec_sec=0
null=1 | time(0) with time zone |
| time |
prec_sec=0
null=1 | time(0) without time zone |
| time |
prec_sec=3
null=1 | time(3) without time zone |
| time2 | null=1 | time(0) without time zone |
| timestamp (bigquery) |
prec_sec=0
null=1 | timestamp(0) with time zone |
| timestamp (db2) |
prec_sec=0
null=1 | timestamp(0) without time zone |
| timestamp (hana) |
prec_sec=0
null=1 | timestamp(0) without time zone |
| timestamp (ingres) |
prec_sec=0
null=1 | timestamp(0) without time zone |
| timestamp (mysql) |
prec_sec=0
null=1 | timestamp(0) with local time zone |
| timestamp (oracle) |
prec_sec=0
null=1 | timestamp(0) without time zone |
| timestamp (sqlserver) |
bytelen=10
null=1 | byte(10) |
| timestamp (sybase) |
bytelen=10
null=1 | byte varying(10) |
| timestamp with local time zone |
prec_sec=0
null=1 | timestamp(0) with local time zone |
| timestamp with local tz (oracle) |
prec_sec=0
null=1 | timestamp(0) with local time zone |
| timestamp with time zone |
prec_sec=0
null=1 | timestamp(0) with time zone |
| timestamp with tz (oracle) |
prec_sec=0
null=1 | timestamp(0) with time zone |
| timestamp |
prec_sec=0
null=1 | timestamp(0) without time zone |
| tinyint signed |
bytelen=1
null=1 | i1 |
| tinyint unsigned |
bytelen=1
null=1 | smallint |
| tinyint |
bytelen=1
null=1 | smallint |
| uniqueidentifier |
bytelen=16
null=1 | byte(16) |
| unitext |
charlen=0
null=1 | long nvarchar |
| univarchar |
charlen=10
null=1 | nvarchar(10) |
| unsigned bigint |
bytelen=8
null=1 | decimal(20) |
| unsigned int |
bytelen=4
null=1 | bigint |
| unsigned smallint |
bytelen=2
null=1 | integer |
| urowid |
bytelen=100
charlen=100 encoding=US-ASCII null=1 | varchar(100) |
| varbinary |
bytelen=10
null=1 | byte varying(10) |
| varbinary (sybase) |
bytelen=10
null=1 | byte varying(10) |
| varbinary(max) | null=1 | long byte |
| varbyte |
bytelen=10
null=1 | byte varying(10) |
| varchar |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(40) |
| varchar |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(20) |
| varchar (sybase) |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar (sybase) |
bytelen=8000
encoding=UTF-8 null=1 | varchar(8000) |
| varchar (sybase) |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(40) |
| varchar (sybase) |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(20) |
| varchar(max) |
encoding=WINDOWS-1252
null=1 | long varchar |
| varchar2 |
bytelen=10
encoding=UTF-8 null=1 | varchar(10) |
| varchar2 |
bytelen=40
charlen=10 encoding=UTF-8 null=1 | varchar(40) |
| varchar2 |
bytelen=10
encoding=WINDOWS-1252 null=1 | varchar(20) |
| vargraphic |
charlen=10
null=1 | nvarchar(10) |
| xml |
charlen=0
null=1 | long nvarchar |
| year (mysql) | null=1 | smallint |