Creating Your Web Database CHAPTER 8 205 Table shows the TEXT and BLOB types. The maximum length of a TEXT field in characters is the maximum size in bytes of files that could be stored in that field. TABLE Type TINYBLOB TEXT and BLOB Types Maximum Length (Characters) 2 -1 (that is, 255) 28 -1 (that is, 255) 216 -1 (that is, 65,535) 216 -1 (that is, 65,535) 224-1 (that is, 16,777,215) 224-1 (that is, 16,777,215) 232-1 (that is, 4,294,967,295) 232-1 (that is, 4,294,967,295) 8 Description A tiny binary large object (BLOB) field A tiny TEXT field A normal sized BLOB field A normal sized. | 205 Creating Your Web Database Chapter 8 Table shows the TEXT and BLOB types. The maximum length of a TEXT field in characters is the maximum size in bytes of files that could be stored in that field. Table TEXT and BLOB Types Type Maximum Length Characters Description TINYBLOB 28 -1 that is 255 A tiny binary large object BLOB field TINYTEXT 28 -1 that is 255 A tiny TEXT field BLOB 216-1 that is 65 535 A normal sized BLOB field TEXT 216 -1 that is 65 535 A normal sized TEXT field MEDIUMBLOB 224-1 that is 16 777 215 A medium-sized BLOB field MEDIUMTEXT 224-1 that is 16 777 215 A medium-sized TEXT field LONGBLOB 232-1 that is 4 294 967 295 A long BLOB field LONGTEXT 232-1 that is 4 294 967 295 A long TEXT field 8 Creating Your Web Database Table shows the ENUM and SET types. Table SET and ENUM Types Type Maximum Values in Set Description ENUM valuer value2 . 65535 Columns of this type can only hold one of the values listed or NULL. SET value1 value2 . 64 Columns of this type can hold a set of the specified values or NULL. 206 Using MySQL Part II Further Reading For more information you can read about setting up a database at the MySQL online manual at http . Next Now that you know how to create users databases and tables you can concentrate on interacting with the database. In the next chapter we ll look at how to put data in the tables how to update and delete it and how to query the database. 9 Working with Your MySQL .
