Page 1 of 1

VARCHAR vs TINYTEXT

Posted: Sat Nov 27, 2010 9:58 pm
by someguyhere
I'm storing a series of URLs in a MySQL DB for a content management system, and it seems like TINYTEXT would be the right string type, but I noticed that Wordpress uses VARCHAR to store their URLS.

Which is the better approach?

Re: VARCHAR vs TINYTEXT

Posted: Sun Nov 28, 2010 12:36 am
by requinix
It's mostly internal stuff. Otherwise, a TINYTEXT and a VARCHAR(<256) are practically identical.