Mysql Memory Storage Engine biggest text size possible -



Mysql Memory Storage Engine biggest text size possible -

i have chat scheme using storage engine [memory] varchar 255 way short, field type should use? dont plan on indexing field.

you can't utilize blob or text in memory table, may able utilize longer varchar depending on version of mysql:

values in varchar columns variable-length strings. length can specified value 0 255 before mysql 5.0.3, , 0 65,535 in 5.0.3 , later versions. effective maximum length of varchar in mysql 5.0.3 , later subject maximum row size (65,535 bytes, shared among columns) , character set used.

http://dev.mysql.com/doc/refman/5.0/en/char.html

mysql memory

Comments

Popular posts from this blog

iphone - Dismissing a UIAlertView -

intellij idea - Update external libraries with intelij and java -

javascript - send data from a new window to previous window in php -