MS SQL Server

www.altova.com Dieses Kapitel drucken Vorherige Seite Eine Ebene nach oben Nächste Seite

Startseite >  Anhänge > Datentypen in DB, die anhand von XML-Schemas generiert wurden >

MS SQL Server

Bei Generierung eines XML-Schemas anhand einer MS SQL-Datenbank (DB) werden die MS SQL Server DB-Datentypen, wie unten in der Tabelle gezeigt, in XML-Schema-Datentypen konvertiert.

 

XML-Schema-Datentyp

MS SQL Server-Datentyp

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

Same as xs:string

xs:token

Same as xs:string

xs:Name

Same as xs:string

xs:NCName

Same as xs:string

xs:anyURi

Same as xs:string

xs:QName

Same as xs:string

xs:NOTATION

Same as 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

Same as xs:hexBinary

xs:integer

int

xs:int

int

xs:negativeInteger

Int (constrained to {...,-2,-1})

xs:positiveInteger

Int (constrained to {1,2,...})

xs:nonNegativeInteger

int (constrained to {0,1,2,...})

xs:nonPositiveInteger

int (constrained to {...,-2,-1,0})

xs:unsignedInt

int (additional constraints)

xs:short

smallint

xs:unsignedShort

smallint (additional constraints)

xs:long

bigint

xs:unsignedLong

bigint (additional constraints)

xs:byte

tinyint

xs:unsignedByte

tinyint (additional constraints)

 


© 2019 Altova GmbH