Should I use varchar or enum

Hi,

I have a field that have about 50 possible values. The values are about 10-25 byte long. I am wondering if it is better to use the enum type or varchar. WHERE will be used very extensively on this field, so sorting/searching performance is very important. Thank you very much!

Alex

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!