CodingForums.com - View Single Post - When I create an attribute column with "MEDTEXT" does mySql Reserve 16 chars each row

ModestLibrarian · 12-24-2012, 08:34 AM

When I create an attribute column with "MEDTEXT" does mySql Reserve 16 chars for each row?
I am making an "account system" and I have Meta data that can be associated with users.
Some meta data is 1 or 0. But sometimes it can be a lengthy description for the user.
That's a lot of space to reserve for parts of the table that don't need it.

Thank you for the help.

12-24-2012, 08:34 AM	PM User \| #1
ModestLibrarian New to the CF scene Join Date: Dec 2012 Posts: 4 Thanks: 2 Thanked 0 Times in 0 Posts	When I create an attribute column with "MEDTEXT" does mySql Reserve 16 chars each row When I create an attribute column with "MEDTEXT" does mySql Reserve 16 chars for each row? I am making an "account system" and I have Meta data that can be associated with users. Some meta data is 1 or 0. But sometimes it can be a lengthy description for the user. That's a lot of space to reserve for parts of the table that don't need it. Thank you for the help.