Posted by anilkmakhija on 07/19/07 15:11

I need to store 256 bit hash (SHA-2 alogrithmn) in one of the table's
primary key. I would prefer to use numeric data type rather varchar
etc.

* Decimal datatype range is -10^38 +1 to 10^38 -1. I can split my 256
bit hash into two decimal(38, 0) type columns as composite key
* I can store the hash as varbinary. I never used it and don't have
much understanding in terms of query writing complexities and dealing
it through ADO (data type etc.)

It would be heavy OLTP type of systems with hash based primary key
used in joins for data retrieval as well.

Please provide your expert comments on this.

Regards
Anil

• Next in forum: Re: Use decimal or varbinary data type?
• Prev in forum: Default value being a concatenation of other columns
• Thread view: Use decimal or varbinary data type?

[Reply to this message]