column type for byte array (md5 algorithm)

[gomzi]

hi,
I would like to know as to what the column type should be, in case i want to store some text in the encrypted format. i m using md5 alogrithm available in .net.

I tried using binary, but it didnt work...some strange characters were inserted into the table when i used it.
thanks,
gomzi.

[ScarletPimpernal]

Hi Gomzi,

Try to define the datatype which supports Numeric,Charact ers and Special Characters.

For Ex:

Varchar
Text
.
etc


Thanks,
Scarlet

hi,
I would like to know as to what the column type should be, in case i want to store some text in the encrypted format. i m using md5 alogrithm available in .net.

I tried using binary, but it didnt work...some strange characters were inserted into the table when i used it.
thanks,
gomzi.