Gregory Wood wrote:
> Best, depending on the scenario. In cases where you are using a fixed number
> of characters, there's no need for the overhead of a varchar. For instance
> if you are storing state abbreviations, they will ALWAYS be 2 characters.
Does anyone else get annoyed when going on to an american site to
register or buy something and find that the state field is only
2 characters long?
Remember, America != World. Be careful when you say always...
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/