Mapping Microsoft SQL Server Datatype to XSD Type
Note: Only those MS SQL data types that are listed in the following table are supported.
| Database Type | XSD Type |
|---|---|
| nchar(n) | string |
| datetime | string |
| binary(n) | base64Binary |
| decimal(p,s) | double |
| float | double |
| money | double |
| real | double |
| smalldatetime | string |
| smallint | int |
| smallmoney | double |
| tinyint | int |
| uniqueidentifier | string |
| varbinary(n) | base64Binary |
| bit | int |
| bigint | long |
| datetimeoffset | string |
| date | string |
| varchar(max) | string |
| char(n) | string |
| int | int |
| numeric | double |
| nvarchar | string |
| timestamp | base64Binary |