how we can store the e mail id into a database? i mean which datatype is used for storing e mail id's.
+3
A:
The natural choice would be a VARCHAR or the equivalent in your DBMS. There really isn't any reason to store an email address as anything other than a text string.
Greg Hewgill
2009-07-10 06:46:42
there is one variable left - number of characters :)
Evgeny
2009-07-10 07:18:05
A:
Type VARCHAR. I would also suggest that you encrypt the email addresses, using an algorithm and a secret salt key. Emails are sensitive information and is a good idea to store them encrypted so in case of data theft your clients wont find themselves on spam lists.
Elzo Valugi
2009-07-10 10:06:28