On Thursday 14 May 2009 09:53:58 am Fish Kungfu wrote: > Since MAC addreses also contain letters, BIGINT wouldn't work. So, yes, I > would say go with CHAR(12). > > On May 14, 2009 9:43 AM, "Ilia KATZ" <ik...@dane-elec.co.il> wrote: > > Hi. > Currently I have a table: > 1. MAC address defined as BIGINT > 2. MAC address set as primary key > > Should I consider changing it to CHAR(12)? > > Replies will be appreciated. > Ilia
And, if you use default charsets of anything else, make sure you set this column to CHARACTER SET ascii. A smaller index is a happier index. kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org