OneData 10.7 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Managing an Object Structure | SQL Server Data Types Supported in OneData
 
SQL Server Data Types Supported in OneData
When you create a column in OneData the data type of the column created in SQL Server is as follows:
In OneData, if the data type is...
The data type in SQL Server is...
Numeric
NUMERIC
Varchar
NVARCHAR (Supports Unicode) / VARCHAR
Character
NCHAR (Supports Unicode) / CHAR
File Type
NVARCHAR / VARCHAR
Date
DATE
TimeStamp
DATETIME
Boolean
BIT
Percentage
NUMERIC
DataBase Sequence
NUMERIC IDENTITY
Optional Database Sequence
NUMERIC
Contiguous Sequence
NUMERIC
You can import a table created in an external system into OneData using the import features update schema, add from remote table, and synchronize structure. OneData supports the following data types in SQL Server:
If SQL Server data type is...
OneData identifies the Data Type as...
bigint
Numeric
decimal
Numeric
float
Numeric
int
Numeric
numeric
Numeric
tinyint
Numeric
real
Numeric
smallint
Numeric
char
Char
nchar
Char
uniqueidentifier
Char
varchar
Varchar
nvarchar
Varchar
date
Date
datetime
Date
datetime2
Timestamp
smalldatetime
Timestamp
time
Timestamp
varbinary
File type
bit
Boolean