Unterstützte Datenbank-Datentypen des Location Intelligence-Moduls
Diese Datenbank-Datentypen werden automatisch einem der unterstützte Datentypen des Location Intelligence-Moduls wie folgt zugeordnet.
| Datenbank-Datentyp | Unterstützter Datentyp |
|---|---|
| SQL Server | |
| tinyint | SHORT_INTEGER |
| smallint | SHORT_INTEGER |
| int | INTEGER |
| bigint | LONG_INTEGER |
| float | DOUBLE |
| real | DOUBLE |
| decimal(10, 5) | DOUBLE |
| numeric(10, 5) | DOUBLE |
| date | DATE |
| time | TIME |
| datetime | DATE_TIME |
| smalldatetime | DATE_TIME |
| char(10) | STRING |
| varchar(10) | STRING |
| nchar(10) | STRING |
| nvarchar(10)G | STRING |
| binary(10) | BINARY |
| varbinary(10) | BINARY |
| PostGIS | |
| smallint | SHORT_INTEGER |
| integer | INTEGER |
| bigint | LONG_INTEGER |
| numeric(10, 5) | DOUBLE |
| real | DOUBLE |
| double precision | DOUBLE |
| serial | INTEGER |
| bigserial | LONG_INTEGER |
| bytea | BINARY |
| date | DATE |
| time | TIME |
| timestamp | DATE_TIME |
| character(10) | STRING |
| character varying(10) | STRING |
| nchar(10) | STRING |
| Oracle | |
| NUMBER | DOUBLE |
| CHAR(10) | STRING |
| VARCHAR(10) | STRING |
| VARCHAR2(10) | STRING |
| NCHAR(10) | STRING |
| NVARCHAR2(10) | STRING |
| DATE | DATE_TIME |
| TIMESTAMP | DATE_TIME |
| BLOB | BINARY |
| SAP HANA | |
| tinyint | SHORT_INTEGER |
| smallint | SHORT_INTEGER |
| integer | INTEGER |
| bigint | LONG_INTEGER |
| smalldecimal | DOUBLE |
| decimal(10, 5) | DOUBLE |
| real | DOUBLE |
| double | DOUBLE |
| float(30) | DOUBLE |
| varchar(30) | STRING |
| nchar(10) | STRING |
| nvarchar(30) | STRING |
| alphanum(30) | STRING |
| date | DATE |
| time | TIME |
| seconddate | DATE_TIM |
| timestamp | DATE_TIM |
| varbinary(30) | BINARY |