Page 1 of 1

MySQL column for 500 characters storage

Posted: Mon Mar 21, 2005 11:18 am
by Calimero
Can anyone tell me which type of column in MySQL table should I declare for storing 500 alfanumeric characters.

It will be used in Forum type applications - with PHP and Apache.

So speed and safety ( generaly)


Thanks Ahead !

Posted: Mon Mar 21, 2005 11:20 am
by feyd
http://dev.mysql.com/doc/mysql/en/column-types.html

try looking at the manual next time.

...

Posted: Mon Mar 21, 2005 11:24 am
by Calimero
Well, I did - several times in the past.

But half of those I don't understand, and the other half I use - but am still not sure what the writer wanted to say.


So I was hoping for just a quick tip - of the type of column, nothing more.



Thanks ahead !

Posted: Mon Mar 21, 2005 11:34 am
by feyd
well... you'll need a string-like type. So that's VARCHAR, CHAR, TEXT, MEDIUMTEXT, LONGTEXT, and TINYTEXT.. look at the storage capacity of each one.