sql server . How they can be conveted to valid TeraData types

Database

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

2 REPLIES
Senior Apprentice

Re: sql server . How they can be conveted to valid TeraData types

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/titl...

(small)money doesn't exist (use DECIMAL instead) 

DateTime -> TIMESTAMP

Varchar/nVarchar -> VARCHAR CHARACTER SET LATIN/UNICODE

Re: sql server . How they can be conveted to valid TeraData types

Thank you