MySQL Driver getTypeInfo()
- Last Updated: July 12, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The following table provides getTypeInfo() results for MySQL 5.0.x and 5.1.
|
TYPE_NAME = bigint
|
|
|
TYPE_NAME = bigint unsigned
|
|
|
TYPE_NAME = binary
|
|
|
TYPE_NAME = bit
|
|
|
TYPE_NAME = blob
|
|
|
TYPE_NAME = char
|
|
|
TYPE_NAME = date
|
|
|
TYPE_NAME = datetime
|
|
|
TYPE_NAME = decimal
|
|
|
TYPE_NAME = decimal unsigned
|
|
|
TYPE_NAME = double
|
|
|
TYPE_NAME = double unsigned
|
|
|
TYPE_NAME = float
|
|
|
TYPE_NAME = float unsigned
|
|
|
TYPE_NAME = integer
|
|
|
TYPE_NAME = integer unsigned
|
|
|
TYPE_NAME = longblob
|
|
|
TYPE_NAME = longtext
|
|
|
TYPE_NAME = mediumblob
|
|
|
TYPE_NAME = mediumint
|
|
|
TYPE_NAME = mediumint unsigned
|
|
|
TYPE_NAME = mediumtext
|
|
|
TYPE_NAME = smallint
|
|
|
TYPE_NAME = smallint unsigned
|
|
|
TYPE_NAME = text
|
|
|
TYPE_NAME = time
|
|
|
TYPE_NAME = timestamp
|
|
|
TYPE_NAME = tinyblob
|
|
|
TYPE_NAME = tinyint
|
|
|
TYPE_NAME = tinyint unsigned
|
|
|
TYPE_NAME = tinytext
|
|
|
TYPE_NAME = varbinary
|
|
|
TYPE_NAME = varchar
|
|
|
TYPE_NAME = year
|
|