재우니의 블로그



The gateway converts Microsoft SQL Server data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Microsoft SQL ServerOracleComment
BIGINTNUMBER(19) 
BINARYRAW-
BITNUMBER(3)-
CHARCHAR-
DATETIMEDATEFractional parts of a second are truncated
DECIMALNUMBER(p[,s])-
FLOATFLOAT(49)-
IMAGELONG RAW-
INTEGERNUMBER(10)NUMBER range is -2,147,483,647 to 2,147,483,647
MONEYNUMBER(19,4)-
NCHARNCHAR-
NTEXTLONG-
NVARCHARNCHAR-
NUMERICNUMBER(p[,s])-
REALFLOAT(23)-
SMALL DATETIMEDATEThe value for seconds is returned as 0
SMALL MONEYNUMBER(10,4)-
SMALLINTNUMBER(5)NUMBER range is -32,767 to 32,767
TEXTLONG-
TIMESTAMPRAW-
TINYINTNUMBER(3)-
UNIQUEIDENTIFIERCHAR(36) 
VARBINARYRAW-
VARCHARVARCHAR2-