|
Building Queries and Data Views
|
Database-Specific Names
This section includes tables showing the database-specific names and the corresponding Liquid Data data types. This section includes the following:
Oracle Names
The following table maps Oracle names to Liquid Data data types.
|
Oracle Name
|
Liquid Data Data Type
|
|
FLOAT
|
xs:float
|
|
BFILE
|
not supported
|
|
LONG
|
not supported
|
|
LONG RAW
|
not supported
|
|
NCHAR
|
xs:string
|
|
NCLOB
|
not supported
|
|
NUMBER
|
xs:decimal
|
|
NVARCHAR2
|
xs:string
|
|
RAW
|
xs:string
|
|
ROWID
|
xs:string
|
|
UROWID
|
not supported
|
|
VARCHAR2
|
xs:string
|
Microsoft SQL Server Names
The following table maps Microsoft SQL Server names to Liquid Data data types.
|
SQL Name
|
Liquid Data Data Type
|
|
DATETIME
|
xs:dateTime
|
|
IMAGE
|
not supported
|
|
INT
|
xs:integer
|
|
MONEY
|
xs:float
|
|
NTEXT
|
xs:string// too big?
|
|
NVARCHAR
|
xs:string
|
|
SMALLDATETIME
|
xs:dateTime
|
|
SMALLMONEY
|
xs:float
|
|
SQL_VARIANT
|
xs:string
|
|
UNIQUEIDENTIFIER
|
xs:string
|
DB2 Names
The following table maps DB2 data types to Liquid Data data types.
|
DB2 Name
|
Liquid Data Data Type
|
|
CHARACTER
|
xs:string
|
|
CHARACTER (for bit data)
|
xs:string
|
|
DATALINK
|
xs:string
|
|
LONG VARCHAR
|
xs:string
|
|
LONG VARCHAR (for bit data)
|
xs:string
|
|
VARCHAR (for bit data)
|
xs:string
|
Sybase Names
The following table maps Sybase data types to Liquid Data data types.
|
Sybase Name
|
Liquid Data Data Type
|
|
SYSNAME
|
xs:string
|
|
TEXT
|
xs:string
|
Informix Names
The following table maps Informix data types to Liquid Data data types.
|
Informix Name
|
Liquid Data Data Type
|
|
BLOB
|
not supported
|
|
BYTE
|
not supported
|
|
BOOLEAN
|
xs:booean
|
|
CHAR(n)
|
xs:string
|
|
CHARACTER(n)
|
xs:string
|
|
CLOB
|
not supported
|
|
DATE
|
xs:date
|
|
DATETIME
|
xs:dateTime
|
|
DEC/DECIMAL
|
xs:decimal
|
|
DOUBLE PRECISION/FLOAT
|
xs:double
|
|
INT/INTEGER
|
xs:integer
|
|
INT8
|
xs:long
|
|
INTERVAL
|
not supported
|
|
LVARCHAR
|
xs:string
|
|
MONEY
|
xs:float
|
|
NCHAR
|
xs:string
|
|
NUMERIC
|
xs:decimal
|
|
REAL
|
xs:float
|
|
SMALLFLOAT
|
xs:float
|
|
SMALLINT
|
xs:short
|
|
TEXT
|
xs:string
|
