Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What type to use for email and what size
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01196171
Message ID:
01196176
Views:
7
>I am back to my SQL Server project (which was on a back burner for a while). So for those who don't want to read newbie questions, put me in a twit <g>.
>
>I am creating a table where one of the fields is Email Address. In my VFP table I used a 100 Char type field. Which is probably a lot of waste since only a few emails would be so long. What type and what length would you recommend for email address?
>
>Thank you.

varchar(255) or something in that range should do it.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform