You might even want to plan for longer MAC addresses. I don't follow developments in that area, but they had to go from IP4 to IP6 and they might have to introduce longer MAC addresses.
It isn't hard to change a MySQL field definition, but your applications would be more of a problem. >-----Original Message----- >From: Ilia KATZ [mailto:ik...@dane-elec.co.il] >Sent: Thursday, May 14, 2009 9:26 AM >To: mysql@lists.mysql.com >Subject: MAC address as primary key - BIGINT or CHAR(12) > >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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org