Char is more efficient when selecting but less efficient when storing (wastes space). It is a trade off so there really isn't a "right" answer. Do some experimenting and see what works best for you.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
