VARCHAR vs TINYTEXT

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
someguyhere
Forum Contributor
Posts: 181
Joined: Sun Jul 27, 2008 3:24 pm

VARCHAR vs TINYTEXT

Post 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?
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: VARCHAR vs TINYTEXT

Post by requinix »

It's mostly internal stuff. Otherwise, a TINYTEXT and a VARCHAR(<256) are practically identical.
Post Reply