Eggzorcist Posted July 28, 2009 Share Posted July 28, 2009 I'm currently working on an application which would need html information to be stored within the sql database. What are the best data-types in order to make a long html code easy to execute. Thanks Link to comment https://forums.phpfreaks.com/topic/167759-solved-storing-html-in-mysql-without-problems/ Share on other sites More sharing options...
mmarif4u Posted July 28, 2009 Share Posted July 28, 2009 I will use text in this case. Link to comment https://forums.phpfreaks.com/topic/167759-solved-storing-html-in-mysql-without-problems/#findComment-884655 Share on other sites More sharing options...
Eggzorcist Posted July 28, 2009 Author Share Posted July 28, 2009 How long can a text or a longtext data-type be? thanks Link to comment https://forums.phpfreaks.com/topic/167759-solved-storing-html-in-mysql-without-problems/#findComment-884658 Share on other sites More sharing options...
mmarif4u Posted July 28, 2009 Share Posted July 28, 2009 BLOB,TEXT: A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. MEDIUMBLOB,MEDIUMTEXT: A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters. LONGBLOB,LONGTEXT: A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. http://dev.mysql.com/doc/refman/5.0/en/blob.html Link to comment https://forums.phpfreaks.com/topic/167759-solved-storing-html-in-mysql-without-problems/#findComment-884660 Share on other sites More sharing options...
Eggzorcist Posted July 28, 2009 Author Share Posted July 28, 2009 Thanks a lot. Link to comment https://forums.phpfreaks.com/topic/167759-solved-storing-html-in-mysql-without-problems/#findComment-884662 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.