June 2005
Intermediate
720 pages
20h 6m
English
Selecting the proper column type for your tables is key to a successful database. Table B.10 lists the different string, number, and other types you can use, along with how much space they will take up on the server’s hard drive. When choosing a type for each column, you should use the most efficient (i.e., the most size-frugal) data type given what the largest value of the column could be.
| MySQL Data Types | ||
|---|---|---|
| Type | Size | Description |
| CHAR[Length] | Length bytes | A fixed-length field from 0 to 255 characters long |
| VARCHAR[Length] | String length + 1 bytes | A variable-length field from 0 to 255 characters long |
| TINYTEXT | String length + 1 bytes | A string with a maximum length of 255 characters ... |
Read now
Unlock full access