Posted by Dan Guzman on 08/10/05 04:07

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" <bjzamora@hotmail.com> wrote in message
news:1123625751.632127.142510@g43g2000cwa.googlegroups.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.
>

[Back to original message]