FRIHOSTFORUMSFAQTOSBLOGSDIRECTORY
You are invited to Log in or Register a Frihost Account!

can we increase mysql field size more than 255 cahrs

 


openaasman
i want to increase the table field size more than 255 chars as my data is more in that field. please tell me whether we can increase mysql field size more than 255 chars or not
mathiaus
I assume your using varchar right? Change the field type to Text then you can have up to 65,535 characters Smile
Rhysige
And if that isnt enough then there should be a "blob" field aswell... though generally I think blob is used for serialised objects.
mathiaus
blob also has 65,535 characters(bytes). If you need more than that ...
mediumtext - 16,777,215
longtext - 4,294,967,295 Shocked
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.