Email Activation Guid

Question

User822391386 posted

Hi guys

Simple question, what data type should my database field be when I save a Guid for email activation?

Thanks

Tiaan 

Answer 1

User-1882799931 posted

You can use uniqueidentifier data type (SQL server)... or a varchar where you save the GUID generated from your app.

Answer 2

User822391386 posted

 janctil

The thing is I use the built in NewGuid function in vb.net to generate a VERY long string. SHould I use varchar? How many shoudl the characters between brackets be e.g varchar(100)?

Tiaan

Answer 3

User-1498408751 posted

Off the top of my head i think it's 32 characters long. varchar(40) should do the trick. Try a google search to double check the length

Answer 4

User-1882799931 posted

yeah, varchar(40) is enough 

Answer 5

User-1199946673 posted

or a varchar where you save the GUID generated from your app.

 

Why can a GUID generated in code not be stored in a uniqueidentifier column in SQL Server? It always works for me!

Answer 6

User-1882799931 posted

 never try this this, but your right! Each time i work with uniqueidentifier data type, I always get my GUID from database (NEWID).