MS SQL Server
When an XML Schema is generated from an MS SQL Server database (DB), the MS SQL Server DB datatypes are converted to XML Schema datatypes as listed in the table below.
MS SQL Server Datatype | XML Schema Datatype |
uniqueidentifier | xs:ID |
char | xs:string |
nchar | xs:string |
varchar | xs:string |
nvarchar | xs:string |
text | xs:string |
ntext | xs:string |
sysname | xs:string |
bit | xs:boolean |
real | xs:float |
float | xs:double |
decimal | xs:decimal |
money | xs:decimal |
smallmoney | xs:decimal |
datetime | xs:dateTime |
smalldatetime | xs:dateTime |
binary | xs:base64Binary |
varbinary | xs:base64Binary |
image | xs:base64Binary |
integer | xs:integer |
smallint | xs:short |
bigint | xs:long |
tinyint | xs:byte |