Page 1 of 1

long characters in mysql

Posted: Wed Feb 16, 2005 1:21 am
by pleigh
hi there,

what data type of a field in mysql do you guys recommend, blob, medium blob, long blob....etc.

i am making a forum like page..

thanks

Posted: Wed Feb 16, 2005 1:31 am
by feyd
the blob types are for binary data, I'd suggest 'text' types. Your typical post will rarely exceed the size of TEXT (64KB). If you are concerned people may get over that (unlikely) you can use MEDIUMTEXT (16MB)

Posted: Wed Feb 16, 2005 1:34 am
by pleigh
oh..thanks feyd.. :)