Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Credit Card format

Author  Topic 

ggr_fi
Starting Member

3 Posts

Posted - 2009-03-09 : 10:35:31
Hello ALL
I need to store Credit Card number in Customers table that i collected From Customers via Windows form ( Vb.net)
What date Type to use to store Credit card number in my Customers Table (is it bigInt??)

Thank you for you help

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-03-09 : 10:43:07
VARCHAR mostly. If you are going to create a HASH value instead (and you should) binary(8).



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -