Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2005 @ 13:01:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

For the data type mappings you can pretty much use the 'Oracle to ANSI' data type mappings described in Oracle's SQL Reference manual.

This describes the different 'NUMBER' to 'Integer, DECIMAL, FLOAT' types etc.

The one additional (not ANSI) point would be

     VARCHAR2() to VARCHAR() CHARACTER SET LATIN
     NVARCHAR2() to VARCHAR() CHARACTER SET UNICODE

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>