When doing the CMS, insert the news content, because the data inserted too much, the error. An error can not be inserted, the first time to think of text type data size limit, on the Internet search, change the field type on it. When doing the project, use the Baidu editor.
Java and MySQL data types corresponding to the list
Table 20.25. mysql Types to Java Types for Resultset.getobject () MySQL Type Name return value OFGETCOLUMNCLASSN Ame returned as Java Class bit (1) (new in MySQL-5.0) bit Java.lang.Boolean bit (> 1) (new in MySQL-5.0) bit B Yte[] TINYINT TINYINT java.lang.boolean if The configuration Property tinyint1isbit is set To true (the default) and the storage size is 1, orjava.lang.integer if not. Bool, boolean TINYINT See tinyint, above as these are aliases (1), Fortinyint. Smallint[(M)] [UNSIGNED] SMALLINT [UNSIGNED] java.lang.integer (regardless ifunsigned or not) mediumint[(m) ] [UNSIGNED] mediumint [UNSIGNED] java.lang.integer, if unsignedjava.lang.long (c/j 3.1 and earlier) Orjava.lang.integer for c/j 5.0 and later int,integer[(M)] [UNSIGNED] Integer [UNSIGNED] Java.lang.Integer, if unsignedjava.lang.long bigint[(M)] [UNSIGNED] BIGINT [UNSIGNED] Java.lang.Long, if UNSIGNEDjava.math.BigINteger float[(m,d)] FLOAT java.lang.Float double[(m,b)] DOUBLE java.lang.Double decimal[(m[,d))] DECIMAL Java.math.BigDecimal Date Date java.sql.Date datetime datetime java.sql.Timestamp timestamp[(M)] Timestamp Java.sql.Timestamp time Java.sql.Time year[(2|4)] Year if yearisdatetype configuration The property was set to false, then the returned object type Isjava.sql.Short. If set to true (the default), then the returned object is of Typejava.sql.date with the Date set to January 1st, at midnight. char (M) Char java.lang.string (unless the character set for the column is binary, Then byte[] is retu rned. VARCHAR (M) [BINARY] VARCHAR java.lang.string (unless the character set for the column is binary, Then byte [] is returned. BINARY (m) BINARY byte[] VARBINARY (m) VARBINARY byte[] Tinyblob tinyblob byte[] tinytext VARCHAR java.lang.String blob blob Byte[] TEXT VARCHAR java.lang.String mediumblob mediumblob byte[] MediumteXT VARCHAR java.lang.String longblob longblob byte[] longtext VARCHAR ENUM (' java.lang.String ', ' value1 ',...) CHAR java.lang.String SET (' value1 ', ' value2 ',...) CHAR java.lang.String
For the Boolean type, in the MySQL database, the individual thinks that it is not convenient to use the int type, especially in projects with Web page development, representing 0/1, which corresponds to an integer of Java type. When the page is displayed, it can be judged to show the relevant data.
In my concept, the text field in MySQL should have no length limitations, but the fact that today tells me that the length of the text type is limited. Where the MySQL text type has a 64K length limit
The news content in the news release system exceeds the length of the 64k,text already does not apply, mediumtext his length is 16777215 (2^24-1) for 256*64k=16m.
In addition: At first I switched to Longblob (Max 4G), performing the add operation, or unable to insert. I don't know what the reason is. Pending resolution.