This article describes the Java data type and MySQL data type comparison table. Share to everyone for your reference, specific as follows:
Type name |
Display length |
Database type |
Java type |
JDBC Type index (int) |
VARCHAR |
L+n |
VARCHAR |
Java.lang.String |
12 |
CHAR |
N |
CHAR |
Java.lang.String |
1 |
Blob |
L+n |
Blob |
Java.lang.byte[] |
-4 |
TEXT |
65535 |
VARCHAR |
Java.lang.String |
-1 |
INTEGER |
4 |
INTEGER UNSIGNED |
Java.lang.Long |
4 |
TINYINT |
3 |
TINYINT UNSIGNED |
Java.lang.Integer |
-6 |
SMALLINT |
5 |
SMALLINT UNSIGNED |
Java.lang.Integer |
5 |
Mediumint |
8 |
Mediumint UNSIGNED |
Java.lang.Integer |
4 |
BIT |
1 |
BIT |
Java.lang.Boolean |
-7 |
BIGINT |
20 |
BIGINT UNSIGNED |
Java.math.BigInteger |
-5 |
FLOAT |
4+8 |
FLOAT |
Java.lang.Float |
7 |
DOUBLE |
22 |
DOUBLE |
Java.lang.Double |
8 |
DECIMAL |
11 |
DECIMAL |
Java.math.BigDecimal |
3 |
BOOLEAN |
1 |
With tinyint |
|
|
Id |
11 |
PK (INTEGER UNSIGNED) |
Java.lang.Long |
4 |
DATE |
10 |
DATE |
Java.sql.Date |
91 |
Time |
8 |
Time |
Java.sql.Time |
92 |
Datetime |
19 |
Datetime |
Java.sql.Timestamp |
93 |
TIMESTAMP |
19 |
TIMESTAMP |
Java.sql.Timestamp |
93 |
Year |
4 |
Year |
Java.sql.Date |
91
|
For Bolb, generally used for the database storage of pictures, the principle is to make the picture into binary, and then a storage mode, in Java corresponding byte[] array.
For the Boolen type, in the MySQL database, the individual thinks that the type of int replaces better, it is not very convenient for bit operation, especially in the project with Web page development, 0/1, corresponding Java type of integer better.
More information about MySQL interested readers can view the site topics: "MySQL Log operation skills Daquan", "MySQL Transaction operation skills Summary", "MySQL stored process skills encyclopedia", "MySQL database lock related skills summary" and "MySQL commonly used function large summary"
I hope this article will help you with the MySQL database meter.