bolb: 一般用于对图片的数据库存储,原理是把图片打成二进制,然后进行的一种存储方式,
在java中对应byte[]
当前列 | ClassName | ColumnType | DisplaySize | TypeName |
0: | java.lang.Integer | ColumnType:4 | 11 | INTEGER |
1: | java.lang.Integer | ColumnType:-6 | 4 | TINYINT |
2: | java.lang.String | ColumnType:12 | 0 | UNKNOWN |
3: | java.lang.Boolean | ColumnType:-7 | 1 | TINYINT |
4: | java.lang.Integer | ColumnType:5 | 6 | SMALLINT |
5: | java.lang.Integer | ColumnType:4 | 9 | MEDIUMINT |
6: | java.lang.Integer | ColumnType:4 | 11 | INTEGER |
7: | java.lang.Long | ColumnType:-5 | 20 | BIGINT |
8: | java.lang.Double | ColumnType:8 | 22 | DOUBLE |
9: | java.lang.Double | ColumnType:8 | 22 | DOUBLE |
10: | java.lang.Float | ColumnType:7 | 12 | FLOAT |
11: | java.lang.String | ColumnType:12 | 11 | UNKNOWN |
12: | java.lang.String | ColumnType:12 | 11 | UNKNOWN |
13: | java.lang.String | ColumnType:1 | 300 | CHAR |
14: | java.lang.String | ColumnType:12 | 300 | VARCHAR |
15: | java.sql.Date | ColumnType:91 | 10 | DATE |
16: | java.sql.Time | ColumnType:92 | 8 | TIME |
17: | java.sql.Date | ColumnType:91 | 4 | YEAR |
18: | java.sql.Timestamp | ColumnType:93 | 19 | TIMESTAMP |
19: | java.sql.Timestamp | ColumnType:93 | 19 | DATETIME |
20: | [B | ColumnType:-3 | 255 | TINYBLOB |
21: | [B | ColumnType:-4 | 65535 | BLOB |
22: | [B | ColumnType:-4 | 16777215 | MEDIUMBLOB |
23: | [B | ColumnType:-4 | -1 | BLOB |
24: | java.lang.String | ColumnType:12 | 255 | TINYBLOB |
25: | java.lang.String | ColumnType:-1 | 65535 | TEXT |
26: | java.lang.String | ColumnType:-1 | 16777215 | MEDIUMBLOB |
27: | java.lang.String | ColumnType:-1 | -1 | TEXT |
28: | java.lang.String | ColumnType:1 | 3 | CHAR |
29: | java.lang.String | ColumnType:1 | 3 | CHAR |