[dba-SQLServer] How much storage

In that case.

If you use HashBytes('MD5'.........), you get back a 128 bit (16 
byte) hash (aka Message Digest) which is usually represented as a 
string of 32 hex digits
f you use HashBytes('SHA1'.........), you get back a 160 bit (20 
byte)  hash which is usually represented as 40 hex digits

On 24 May 2007 at 21:47, jwcolby wrote:

> >Are you talking about one of the CHECKSUM functions?
> 
> hashbytes 
> 
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: Thursday, May 24, 2007 9:42 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] How much storage
> 
> On 24 May 2007 at 21:23, jwcolby wrote:
> 
> > How much storage is used for varbinary?  I am looking at using the 
> > hash function of SQL Server (built in to SQL Server 2005 now), and it 
> > returns something like 120-180 "somethings", it is defined as 
> > varbinary(8000) maximum.  AFAICT it is a fixed width that varies 
> > depending on the hash algorithm.  Is it returning an array of characters
> with 120-180 elements?
> > Is binary (or varbinary) defined in bits of a 32 bit word?  Is each 
> > binary digit stored as a single position in a character?
> 
> varBinary = Variable length Binary data.  It's just a string of bytes and it
> uses as much as it needs to store whatever chunk of data is put in it.
> 
> Are you talking about one of the CHECKSUM functions?
> 
> 
> 
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>