How to save array of integer numbers in a column in SQL Server 2005

Question

I have a table in SQL Server 2005 with the following properties:

Users (UserID, Username, Password)   where UserID is primary key

I want to save an array of integer numbers in the password attribute in the Users table.

--------------------
 0    1    2    3  
--------------------
1543 6543 7658 8765
--------------------

I plan to save this into the password column.

On the other hand I use pictures instead of texts for password and each picture has a code (4 digit) and a password include 4 picture that produce 16 digit. I want to save these 16 digits (array of Ints) into the Password column

please help me.

thanks

seriously, just don't...!! If it's a password, store it as a password (encrypted and salted of course) — Mitch Wheat
– Mitch Wheat, Commented Dec 26, 2010 at 5:40
of course it must be! You are saving into a column named 'Password'. you wouldn't be storing anything else in there would you? — Mitch Wheat
– Mitch Wheat, Commented Dec 26, 2010 at 5:46
yes it correct but my password is not a password eg. it is Passface — hamed
– hamed, Commented Dec 26, 2010 at 7:25
on the the other hand i use pictures insted texts for password and each picture has a code (4 digit) and a password include 4 picture that produce 16 dgit. i want to save this 16 digit (array of Ints) to Password Column — hamed
– hamed, Commented Dec 26, 2010 at 7:28

Remus Rusanu · Accepted Answer · 2010-12-26 06:10:16Z

2

In general arrays are saved in SQL tables as another table, one table row per array element.

But that does not look though like an array of ints, that looks more like 16 byte vector, probably an MD5 digest. Make a VARBINARY(20) column (this way you can switch to SHA1 without changing the column type) and store the byte array as a ... byte array. See SqlBytes for how to manipulate BINARY and VARBINARY columns in the client.

edited Dec 26, 2010 at 6:10

answered Dec 26, 2010 at 5:53

Remus Rusanu

296k42 gold badges459 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to save array of integer numbers in a column in SQL Server 2005

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related