PDA

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.

Ronski
4-17-02, 01:21 AM
... or use a VARCHAR(255) field, if you're sure the text will never be larger.