FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free 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
Related topics
mysql file size increase
increase php memory size please
Maximum MYSQL database size
Best way to check if BINARY mysql field is zero?
Mysql database size?
Photoshop tips
Login System Tutorial Part 1 Creating Registration
"Drop Down List Box" Using PHP and MySql
How to Configure Heap Size in Eclipse
751 Useful Windows XP Files
html form help needed
Increasing The Font Size
Turn off Remote Avatars.
META Tag How-To
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

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