long characters in mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
pleigh
Forum Contributor
Posts: 445
Joined: Wed Jan 19, 2005 4:26 am

long characters in mysql

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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)
User avatar
pleigh
Forum Contributor
Posts: 445
Joined: Wed Jan 19, 2005 4:26 am

Post by pleigh »

oh..thanks feyd.. :)
Post Reply