|
Pivot
|
Condition
|
Datatype
|
|---|---|---|
|
|
L>0 and D not ø
|
REAL (@L,@D) UNSIGNED
|
|
L=0 or L ø
|
REAL UNSIGNED
|
|
|
|
L>0 and D not ø
|
REAL (@L,@D) UNSIGNED ZEROFILL
|
|
L=0 or L ø
|
REAL UNSIGNED ZEROFILL
|
|
|
P-AutoIdentifier
|
|
INTEGER
|
|
P-Binary
|
L ø or L<=0
|
BINARY
|
|
L is numeric and L<>0
|
BINARY (@L)
|
|
|
P-Boolean
|
|
BOOLEAN
|
|
P-Byte
|
L ø or L<=0
|
BIT
|
|
L is numeric and L<>0
|
BIT (@L)
|
|
|
P-Character
|
Not Unicode and L=0
|
CHAR
|
|
Unicode and L<>0
|
CHAR (@L) UNICODE
|
|
|
Unicode and L=0
|
CHAR UNICODE
|
|
|
Not Unicode and L<>0
|
CHAR(@L)
|
|
|
P-Character Ascii
|
L ø or L<=0
|
CHAR ASCII
|
|
L is numeric and L<>0
|
CHAR(@L) ASCII
|
|
|
P-Character Binary
|
Not Unicode and L<>0
|
CHAR (@L) BINARY
|
|
Unicode and L<>0
|
CHAR (@L) UNICODE BINARY
|
|
|
Not Unicode and L=0
|
CHAR BINARY
|
|
|
Unicode and L=0
|
CHAR UNICODE BINARY
|
|
|
P-Character Unicode
|
L is numeric and L<>0
|
CHAR (@L) UNICODE
|
|
L ø or L<=0
|
CHAR UNICODE
|
|
|
P-Character Unicode Binary
|
L is numeric and L<>0
|
CHAR (@L) UNICODE BINARY
|
|
L ø or L<=0
|
CHAR UNICODE BINARY
|
|
|
P-Currency
|
|
DECIMAL(@L,@D)
|
|
P-Date
|
|
DATE
|
|
P-Datetime
|
|
DATETIME
|
|
P-Decimal
|
L=0 or L ø
|
DECIMAL
|
|
L>0 and D ø
|
DECIMAL (@L)
|
|
|
L>0 and D not ø
|
DECIMAL(@L,@D)
|
|
|
P-Decimal Unsigned
|
L>0 and D ø
|
DECIMAL (@L) UNSIGNED
|
|
L>0 and D not ø
|
DECIMAL (@L,@D) UNSIGNED
|
|
|
L=0 or L ø
|
DECIMAL UNSIGNED
|
|
|
P-Decimal Unsigned Zerofill
|
L>0 and D ø
|
DECIMAL (@L) UNSIGNED ZEROFILL
|
|
L>0 and D not ø
|
DECIMAL (@L,@D) UNSIGNED ZEROFILL
|
|
|
L=0 or L ø
|
DECIMAL UNSIGNED ZEROFILL
|
|
|
P-Double
|
L=0 or L ø
|
DOUBLE PRECISION
|
|
L>0 and D not ø
|
DOUBLE PRECISION (@L,@D)
|
|
|
P-Double Unsigned
|
L>0 and D not ø
|
DOUBLE PRECISION (@L,@D) UNSIGNED
|
|
L=0 or L ø
|
DOUBLE PRECISION UNSIGNED
|
|
|
P-Double Unsigned Zerofill
|
L>0 and D not ø
|
DOUBLE PRECISION (@L,@D) UNSIGNED ZEROFILL
|
|
L=0 or L ø
|
DOUBLE PRECISION UNSIGNED ZEROFILL
|
|
|
P-Float
|
L=0 or L ø
|
FLOAT
|
|
L>0 and D ø
|
FLOAT (@L)
|
|
|
L>0 and D not ø
|
FLOAT (@L,@D)
|
|
|
P-Float Unsigned
|
L>0 and D ø
|
FLOAT (@L) UNSIGNED
|
|
L>0 and D not ø
|
FLOAT (@L,@D) UNSIGNED
|
|
|
L=0 or L ø
|
FLOAT UNSIGNED
|
|
|
P-Float Unsigned Zerofill
|
L>0 and D ø
|
FLOAT (@L) UNSIGNED ZEROFILL
|
|
L>0 and D not ø
|
FLOAT (@L,@D) UNSIGNED ZEROFILL
|
|
|
L=0 or L ø
|
FLOAT UNSIGNED ZEROFILL
|
|
|
P-Integer
|
L ø or L<=0
|
INTEGER
|
|
L is numeric and L<>0
|
INTEGER (@L)
|
|
|
P-Integer Unsigned
|
L is numeric and L<>0
|
INTEGER (@L) UNSIGNED
|
|
L ø or L<=0
|
INTEGER UNSIGNED
|
|
|
P-Integer Unsigned Zerofill
|
L is numeric and L<>0
|
INTEGER (@L) UNSIGNED ZEROFILL
|
|
L ø or L<=0
|
INTEGER UNSIGNED ZEROFILL
|
|
|
P-Long Integer
|
L ø or L<=0
|
BIGINT
|
|
L is numeric and L<>0
|
BIGINT (@L)
|
|
|
P-Long Integer Unsigned
|
L is numeric and L<>0
|
BIGINT (@L) UNSIGNED
|
|
L ø or L<=0
|
BIGINT UNSIGNED
|
|
|
P-Long Integer Unsigned Zerofill
|
L is numeric and L<>0
|
BIGINT (@L) UNSIGNED ZEROFILL
|
|
L ø or L<=0
|
BIGINT UNSIGNED ZEROFILL
|
|
|
P-Longblob
|
|
LONGBLOB
|
|
P-Longtext
|
|
LONGTEXT
|
|
P-Mediumblob
|
|
MEDIUMBLOB
|
|
P-Mediumint
|
L ø or L<=0
|
MEDIUMINT
|
|
L is numeric and L<>0
|
MEDIUMINT (@L)
|
|
|
P-Mediumint Unsigned
|
L is numeric and L<>0
|
MEDIUMINT (@L) UNSIGNED
|
|
L ø or L<=0
|
MEDIUMINT UNSIGNED
|
|
|
P-Mediumint Unsigned Zerofill
|
L is numeric and L<>0
|
MEDIUMINT (@L) UNSIGNED ZEROFILL
|
|
L ø or L<=0
|
MEDIUMINT UNSIGNED ZEROFILL
|
|
|
P-Mediumtext
|
|
MEDIUMTEXT
|
|
P-Multimedia
|
|
BLOB
|
|
P-National Varchar
|
L ø or L<0
|
NATIONAL VARCHAR
|
|
L is numeric and L<>0
|
NATIONAL VARCHAR (@L)
|
|
|
P-National Varchar Binary
|
L is numeric and L<>0
|
NATIONAL VARCHAR (@L) BINARY
|
|
L ø or L<0
|
NATIONAL VARCHAR BINARY
|
|
|
P-Numeric
|
L=0 or L ø
|
NUMERIC
|
|
L>0 and D ø
|
NUMERIC (@L)
|
|
|
L>0 and D not ø
|
NUMERIC (@L,@D)
|
|
|
P-Real
|
L=0 or L ø
|
REAL
|
|
L>0 and D not ø
|
REAL (@L,@D)
|
|
|
P-Smallint
|
L ø or L<=0
|
SMALLINT
|
|
L is numeric and L<>0
|
SMALLINT (@L)
|
|
|
P-Smallint Unsigned
|
L is numeric and L<>0
|
SMALLINT (@L) UNSIGNED
|
|
L ø or L<=0
|
SMALLINT UNSIGNED
|
|
|
P-Smallint Unsigned Zerofill
|
L is numeric and L<>0
|
SMALLINT (@L) UNSIGNED ZEROFILL
|
|
L ø or L<=0
|
SMALLINT UNSIGNED ZEROFILL
|
|
|
P-String
|
|
VARCHAR(@L)
|
|
P-Text
|
|
TEXT
|
|
P-Time
|
|
TIME
|
|
P-Timestamp
|
|
TIMESTAMP
|
|
P-Tinyblob
|
|
TINYBLOB
|
|
P-Tinyint
|
L ø or L<=0
|
TINYINT
|
|
L is numeric and L<>0
|
TINYINT (@L)
|
|
|
P-Tinyint Unsigned
|
L is numeric and L<>0
|
TINYINT (@L) UNSIGNED
|
|
L ø or L<=0
|
TINYINT UNSIGNED
|
|
|
P-Tinyint Unsigned Zerofill
|
L is numeric and L<>0
|
TINYINT (@L) UNSIGNED ZEROFILL
|
|
L ø or L<=0
|
TINYINT UNSIGNED ZEROFILL
|
|
|
P-Tinytext
|
|
TINYTEXT
|
|
P-Varbinary
|
L ø or L<0
|
VARBINARY
|
|
L is numeric and L>=0
|
VARBINARY (@L)
|
|
|
P-Varchar
|
L ø or L<=0
|
VARCHAR
|
|
L is numeric and L=0
|
VARCHAR(@L)
|
|
|
P-Varchar Binary
|
L is numeric and L<>0
|
VARCHAR (@L) BINARY
|
|
L ø or L<0
|
VARCHAR BINARY
|
|
|
P-Wide Character
|
L ø or L<=0
|
NATIONAL CHAR
|
|
L is numeric and L<>0
|
NATIONAL CHAR (@L)
|
|
|
P-Wide Character Binary
|
L is numeric and L<>0
|
NATIONAL CHAR (@L) BINARY
|
|
L ø or L<=0
|
NATIONAL CHAR BINARY
|
|
|
P-Year
|
L ø or L<=0
|
YEAR
|
|
L is numeric and L<>0
|
YEAR(@L)
|
|
Datatype
|
Condition
|
Pivot
|
|---|---|---|
|
BIGINT
|
|
P-Long Integer
|
|
BIGINT (L)
|
|
P-Long Integer
|
|
BIGINT (L) UNSIGNED
|
|
P-Long Integer Unsigned
|
|
BIGINT (L) UNSIGNED ZEROFILL
|
|
P-Long Integer Unsigned Zerofill
|
|
BIGINT UNSIGNED
|
|
P-Long Integer Unsigned
|
|
BIGINT UNSIGNED ZEROFILL
|
|
P-Long Integer Unsigned Zerofill
|
|
BINARY
|
|
P-Binary
|
|
BINARY (L)
|
|
P-Binary
|
|
BIT
|
|
P-Byte
|
|
BIT (L)
|
|
P-Byte
|
|
BLOB
|
|
P-Multimedia
|
|
BOOLEAN
|
|
P-Boolean
|
|
CHAR
|
|
P-Character
|
|
CHAR (L) BINARY
|
|
P-Character Binary
|
|
CHAR (L) UNICODE
|
|
P-Character Unicode
|
|
CHAR (L) UNICODE BINARY
|
|
P-Character Unicode Binary
|
|
CHAR ASCII
|
|
P-Character Ascii
|
|
CHAR BINARY
|
|
P-Character Binary
|
|
CHAR UNICODE
|
|
P-Character Unicode
|
|
CHAR UNICODE BINARY
|
|
P-Character Unicode Binary
|
|
CHAR(L)
|
|
P-Character
|
|
CHAR(L) ASCII
|
|
P-Character Ascii
|
|
DATE
|
|
P-Date
|
|
DATETIME
|
|
P-Datetime
|
|
DECIMAL
|
|
P-Decimal
|
|
DECIMAL (L)
|
|
P-Decimal
|
|
DECIMAL (L) UNSIGNED
|
|
P-Decimal Unsigned
|
|
DECIMAL (L) UNSIGNED ZEROFILL
|
|
P-Decimal Unsigned Zerofill
|
|
DECIMAL (L,D) UNSIGNED
|
|
P-Decimal Unsigned
|
|
DECIMAL (L,D) UNSIGNED ZEROFILL
|
|
P-Decimal Unsigned Zerofill
|
|
DECIMAL UNSIGNED
|
|
P-Decimal Unsigned
|
|
DECIMAL UNSIGNED ZEROFILL
|
|
P-Decimal Unsigned Zerofill
|
|
DECIMAL(L,D)
|
|
P-Decimal
|
|
DOUBLE PRECISION
|
|
P-Double
|
|
DOUBLE PRECISION (L,D)
|
|
P-Double
|
|
DOUBLE PRECISION (L,D) UNSIGNED
|
|
P-Double Unsigned
|
|
DOUBLE PRECISION (L,D) UNSIGNED ZEROFILL
|
|
P-Double Unsigned Zerofill
|
|
DOUBLE PRECISION UNSIGNED
|
|
P-Double Unsigned
|
|
DOUBLE PRECISION UNSIGNED ZEROFILL
|
|
P-Double Unsigned Zerofill
|
|
FLOAT
|
|
P-Float
|
|
FLOAT (L)
|
|
P-Float
|
|
FLOAT (L) UNSIGNED
|
|
P-Float Unsigned
|
|
FLOAT (L) UNSIGNED ZEROFILL
|
|
P-Float Unsigned Zerofill
|
|
FLOAT (L,D)
|
|
P-Float
|
|
FLOAT (L,D) UNSIGNED
|
|
P-Float Unsigned
|
|
FLOAT (L,D) UNSIGNED ZEROFILL
|
|
P-Float Unsigned Zerofill
|
|
FLOAT UNSIGNED
|
|
P-Float Unsigned
|
|
FLOAT UNSIGNED ZEROFILL
|
|
P-Float Unsigned Zerofill
|
|
INTEGER
|
|
P-Integer
|
|
INTEGER (L)
|
|
P-Integer
|
|
INTEGER (L) UNSIGNED
|
|
P-Integer Unsigned
|
|
INTEGER (L) UNSIGNED ZEROFILL
|
|
P-Integer Unsigned Zerofill
|
|
INTEGER UNSIGNED
|
|
P-Integer Unsigned
|
|
INTEGER UNSIGNED ZEROFILL
|
|
P-Integer Unsigned Zerofill
|
|
LONGBLOB
|
|
P-Longblob
|
|
LONGTEXT
|
|
P-Longtext
|
|
MEDIUMBLOB
|
|
P-Mediumblob
|
|
MEDIUMINT
|
|
P-Mediumint
|
|
MEDIUMINT (L)
|
|
P-Mediumint
|
|
MEDIUMINT (L) UNSIGNED
|
|
P-Mediumint Unsigned
|
|
MEDIUMINT (L) UNSIGNED ZEROFILL
|
|
P-Mediumint Unsigned Zerofill
|
|
MEDIUMINT UNSIGNED
|
|
P-Mediumint Unsigned
|
|
MEDIUMINT UNSIGNED ZEROFILL
|
|
P-Mediumint Unsigned Zerofill
|
|
MEDIUMTEXT
|
|
P-Mediumtext
|
|
NATIONAL CHAR
|
|
P-Wide Character
|
|
NATIONAL CHAR (L)
|
|
P-Wide Character
|
|
NATIONAL CHAR (L) BINARY
|
|
P-Wide Character Binary
|
|
NATIONAL CHAR BINARY
|
|
P-Wide Character Binary
|
|
NATIONAL VARCHAR
|
|
P-National Varchar
|
|
NATIONAL VARCHAR (L)
|
|
P-National Varchar
|
|
NATIONAL VARCHAR (L) BINARY
|
|
P-National Varchar Binary
|
|
NATIONAL VARCHAR BINARY
|
|
P-National Varchar Binary
|
|
NUMERIC
|
|
P-Numeric
|
|
NUMERIC (L)
|
|
P-Numeric
|
|
NUMERIC (L,D)
|
|
P-Numeric
|
|
REAL
|
|
P-Real
|
|
REAL (L,D)
|
|
P-Real
|
|
REAL (L,D) UNSIGNED
|
|
|
|
REAL (L,D) UNSIGNED ZEROFILL
|
|
|
|
REAL UNSIGNED
|
|
|
|
REAL UNSIGNED ZEROFILL
|
|
|
|
SMALLINT
|
|
P-Smallint
|
|
SMALLINT (L)
|
|
P-Smallint
|
|
SMALLINT (L) UNSIGNED
|
|
P-Smallint Unsigned
|
|
SMALLINT (L) UNSIGNED ZEROFILL
|
|
P-Smallint Unsigned Zerofill
|
|
SMALLINT UNSIGNED
|
|
P-Smallint Unsigned
|
|
SMALLINT UNSIGNED ZEROFILL
|
|
P-Smallint Unsigned Zerofill
|
|
TEXT
|
|
P-Text
|
|
TIME
|
|
P-Time
|
|
TIMESTAMP
|
|
P-Timestamp
|
|
TINYBLOB
|
|
P-Tinyblob
|
|
TINYINT
|
|
P-Tinyint
|
|
TINYINT (L)
|
|
P-Tinyint
|
|
TINYINT (L) UNSIGNED
|
|
P-Tinyint Unsigned
|
|
TINYINT (L) UNSIGNED ZEROFILL
|
|
P-Tinyint Unsigned Zerofill
|
|
TINYINT UNSIGNED
|
|
P-Tinyint Unsigned
|
|
TINYINT UNSIGNED ZEROFILL
|
|
P-Tinyint Unsigned Zerofill
|
|
TINYTEXT
|
|
P-Tinytext
|
|
VARBINARY
|
|
P-Varbinary
|
|
VARBINARY (L)
|
|
P-Varbinary
|
|
VARCHAR
|
|
P-Varchar
|
|
VARCHAR (L) BINARY
|
|
P-Varchar Binary
|
|
VARCHAR BINARY
|
|
P-Varchar Binary
|
|
VARCHAR(L)
|
|
P-Varchar
|
|
YEAR
|
|
P-Year
|
|
YEAR(L)
|
|
P-Year
|