MAC Address attribute

[xAvailx]

Hi:

I need to store MAC Addresses. What is the standard way of storing this
type of attribute? Datatype? I can't find any discussions about this
anywhere.

Thx for any pointers.

[Dan Guzman]

A MAC address is a binary value. You could store these using a binary data
type (binary or varbinary) or store the hex string notation in a character
datatype (char or varchar). One advantage of a binary data type is lower
space requirements and an advantage of a character data type is that it's a
bit easier to display by application programs.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"xAvailx" <bj******@hotmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Hi:

I need to store MAC Addresses. What is the standard way of storing this
type of attribute? Datatype? I can't find any discussions about this
anywhere.

Thx for any pointers.