data type for 32-bit

#1

I am going to generate 32-bit encryption key with combination of any
number of characters. what data type and its size should I use for
that on MS SQL 2005? will it be nvarchar(max) or nvarchar(4000)
appropriate to use? thanks!

#2

You can use BINARY(4) if the key is always 32-bit. If it will vary then
maybe VARBINARY(4) will be better.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

data type for 32-bit

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

data type for 32-bit - 11-21-2007 , 10:25 AM

Re: data type for 32-bit - 11-21-2007 , 12:26 PM