Wednesday, November 25, 2009

MYSQL Text Field size limitation

MyISAM tables in MySQL have a maximum size of a row of 65,535 bytes, so all the data in a row must fit within that limit. However, the TEXT types are stored outside the table itself and only contribute 9 to 12 bytes towards that limit. (For more information about this refer to the MySQL Manual - Data Storage Requirements chapter).

TEXT data types are also able to store much more data than VARCHAR and CHAR text types so TEXT types are what you need to use when storing web page or similar content in a database.

The maximum amount of data that can be stored in each data type is as follows:

TINYTEXT 256 bytes 
TEXT65,535 bytes~64kb
MEDIUMTEXT 16,777,215 bytes ~16MB
BIGTEXT4,294,967,295 bytes~4GB

In most circumstances the TEXT type is probably sufficient, but if you are coding a content management system it's probably best to use the MEDIUMTEXT type for longer pages to ensure there are no issues with data size limits.

Sunday, November 22, 2009

embed youtube video in customized appearance player

We need to use youtube's "chromeless player"
and the control to the video, we are able to achieve by using Javascripts Player API

Requirement: Flash Player version 8.0 and above

Futher details on how to use this, please refer site below:
http://code.google.com/apis/youtube/js_api_reference.html


OR

i will reveal later.... 




Tuesday, November 3, 2009

To Make a fixed height <UL> to scroll

CSS Code:

.holder UL{
height: 50px;
overflow: auto;
overflow-x: hidden; // this line is to hide the horizontal scroll
}