MySQL

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 >

MySQL

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

 

 

XML-Schema-Datentyp

MySQL-Datentyp

xs:ID

varchar(255)

xs:string

If no facets then varchar (255)

 

else if facet length is set and <= 255
then char

 

else if facet maxLength set and <= 255
then varchar

 

else if maxLength is set and <= 65545

then text

 

else if maxlength is set and <= 16777215
then mediumtext

 

else if maxlength is set and <= 429496295
then longtext

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

tinyint(1)

xs:float

float

xs:double

double

xs:decimal

decimal

xs:duration

timestamp

xs:dateTime

datetime

xs:time

time

xs:date

date

xs:gYearMonth

timestamp(4)

xs:gYear

year(4)

xs:gMonthDay

timestamp(8); constraints to check month, day

xs:gDay

timestamp(8); constraints to check day

xs:gMonth

timestamp(8); constraints to check month

xs:hexBinary

If no facets then blob (255)

 

else if facet length is set and <= 255
then blob

 

else if facet maxLength is set and <= 255
then tinyblob

 

else if maxlength is set and <= 65545
then blob

 

else if maxlength is set and <= 16777215
then mediumblob

 

else if maxlength is set and <= 429496295
then longblob

xs:base64Binary

Same as xs:hexBinary

xs:integer

Integer

xs:int

int

xs:negativeInteger

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

xs:positiveInteger

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

xs:nonNegativeInteger

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

xs:nonPositiveInteger

Integer (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