bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

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

- Microsoft SQL Server Names

- DB2 Names

- Sybase Names

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