TEXT vs Varchar : need your advice.

[eluser]Johan André[/eluser]
I usually use varchar if:

* The content is less than 255 characters

* If I need to do automatic case-insensitive compares ('My article' = 'MY ARTICLE' = 'my article')

All my filereferences is of type varchar. Most of my fields is too (names, slugs, tags, phonenumbers, email-adresses, zipcodes, citynames, adresses, usernames, passwords).