| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Fish Kungfu | Date: | May 14 2009 1:53pm |
| Subject: | Re: MAC address as primary key - BIGINT or CHAR(12) | ||
| View as plain text | |||
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" <ikatz@stripped> 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
| Thread | ||
|---|---|---|
| • MAC address as primary key - BIGINT or CHAR(12) | Ilia KATZ | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Fish Kungfu | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | kabel | 14 May |
| • RE: MAC address as primary key - BIGINT or CHAR(12) | Ilia KATZ | 14 May |
| • RE: MAC address as primary key - BIGINT or CHAR(12) | Jerry Schwartz | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Thomas Spahni | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Jim Lyons | 14 May |
| • RE: MAC address as primary key - BIGINT or CHAR(12) | Daevid Vincent | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Pete Wilson | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Jim Lyons | 14 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Pete Wilson | 14 May |
| • RE: MAC address as primary key - BIGINT or CHAR(12) | Gavin Towey | 15 May |
| • Re: MAC address as primary key - BIGINT or CHAR(12) | Gavin Towey | 15 May |