View Full Version : Using MySQL To Store Text
Atomic-Design
4-16-02, 11:34 AM
How do I set up a table in MySQL so that it can save text? Like, around 255 chararacters?
devinemke
4-16-02, 05:01 PM
create a table of then create a column with the "TEXT" type
CREATE TABLE name_of_table (name_of_column text);
A "TEXT" column can store a maximum length of 65535 (2^16 - 1) characters. If you only need 255 characters then you can use "TINYTEXT" for more efficiency.
... or use a VARCHAR(255) field, if you're sure the text will never be larger.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.