MS SQL Server
Cuando se crea una base de datos MS SQL Server a partir de un esquema XML, los tipos de datos XML Schema se convierten en tipos de datos MS SQL Server tal y como muestra la tabla que aparece a continuación:
Tipo de datos XML Schema | Tipo de datos MS SQL Server |
ID | uniqueidentifier |
xs:string | If no facets |
| { if UNICODE nvarchar (255) |
| else varchar (255) } |
| else |
| { if UNICODE |
| (Size = either length or maxLength) |
| If Size <= 4000 |
| if FacetLengthIsSet then nChar |
| else nVarChar |
| if Size <= 1073741823 then nText } |
| else |
| { if NON-UNICODE |
| (Size = either length or maxLength) |
| If Size <= 8000 |
| if FacetLengthIsSet then char |
| else varchar |
| if Size <= 2147483647 then text } |
xs:normalizedString | Igual que xs:string |
xs:token | Igual que xs:string |
xs:Name | Igual que xs:string |
xs:NCName | Igual que xs:string |
xs:anyURi | Igual que xs:string |
xs:QName | Igual que xs:string |
xs:NOTATION | Igual que xs:string |
xs:boolean | bit |
xs:float | real |
xs:double | float |
xs:decimal | decimal |
xs:duration | datetime |
xs:dateTime | datetime |
xs:time | datetime |
xs:date | datetime |
xs:gYearMonth | datetime |
xs:gYear | datetime |
xs:gMonthDay | datetime |
xs:gDay | datetime |
xs:gMonth | datetime |
xs:hexBinary | If no facets varbinary (255) |
| (Size = either length or maxLength |
| If Size <= 8000 |
| if FacetLengthIsSet then binary |
| else varbinary |
| if Size <= 2147483647 then image |
xs:base64Binary | Igual que xs:hexBinary |
xs:integer | int |
xs:int | int |
xs:negativeInteger | Int (limitado a {...,-2,-1}) |
xs:positiveInteger | Int (limitado a {1,2,...}) |
xs:nonNegativeInteger | int (limitado a {0,1,2,...}) |
xs:nonPositiveInteger | int (limitado a {...,-2,-1,0}) |
xs:unsignedInt | int (restricciones adicionales) |
xs:short | smallint |
xs:unsignedShort | smallint (restricciones adicionales) |
xs:long | bigint |
xs:unsignedLong | bigint (restricciones adicionales) |
xs:byte | tinyint |
xs:unsignedByte | tinyint (restricciones adicionales) |