
	Version 8.2.2	SEARCH INDEX CONTENTS \| PDF BOOKS \| HOME UP PREV NEXT

— Tamino XML Schema User Guide —

Appendix 1: Available and Recommended Datatypes for Mapping to X-Node/SQL

The following table shows the recommended datatype for mapping specific SQL datatypes. The second column of the table shows which TSD types are recommended as the most suitable choices for the corresponding SQL type. Types not explicitly marked as not indexable are indexable.

Datatypes for SQL Mapping

SQL Datatype	Preferred XML Schema/TSD Datatype	Comment
`CHAR`, `VARCHAR`	`xs:string`
`LONGVARCHAR`, `CLOB`	-	not supported
`BIT`	`xs:boolean`
`BIGINT`	-	not supported, could e.g. be mapped to `xs:short`
`INTEGER`	`xs:int`	depending on implementation of SQL database
`SMALLINT`	`xs:short`
`TINYINT`	-	not supported, could e.g. be mapped to `xs:short`
`DECIMAL(precision,scale)`	`xs:decimal`
`NUMERIC(precision,scale)`	`xs:decimal`
`REAL`	`xs:float`
`DOUBLE`	`xs:double`
`DATE`	`xs:date`
`TIME`	`xs:time`
`TIMESTAMP`	-	`xs:datetime` not yet supported, could be mapped to `xs:string`
`INTERVAL(DAY-TIME)`	-	could be mapped to `xs:string`
`INTERVAL(YEAR-MONTH)`	-	could be mapped to `xs:string`
`BINARY`	-	not supported
`VARBINARY`	-	not supported
`LONGVARBINARY`, `BLOB`	-	not supported

SEARCH INDEX CONTENTS | PDF BOOKS | HOME UP PREV NEXT