All Forums Database
vasugupta9 2 posts Joined 10/14
03 Oct 2014
sql server . How they can be conveted to valid TeraData types

Tell how below datatypes in sql server . How they can be conveted to valid TeraData types?

int
Tinyint
Smallint
bigint
Decimal(18,5)
numeric[p[,s]]
float
real
smallmoney
money
Varchar(10)
Char(4)
nvarchar(50)
Smalldatetime
Datetime

Date

dnoeth 4628 posts Joined 11/04
03 Oct 2014

Most datatypes are exactly the same in Teradata, please check the manuals:
http://www.info.teradata.com/htmlpubs/DB_TTU_14_10/index.html#page/SQL_Reference/B035_1143_112A/title.040.2.html
 
(small)money doesn't exist (use DECIMAL instead) 
 
DateTime -> TIMESTAMP
Varchar/nVarchar -> VARCHAR CHARACTER SET LATIN/UNICODE

Dieter

vasugupta9 2 posts Joined 10/14
03 Oct 2014

Thank you

You must sign in to leave a comment.