encrypted value storage
- From: bill <rcairflyer@xxxxxxxxxxx>
- Date: Tue, 19 Feb 2008 14:50:04 -0800 (PST)
I have a varchar column that I would like to encrypt and store within
the same column. Encryption functions return binary. I would change
the column datatype , but certain parties will not change the datatype
to varbinary. I can store the value after explicitly converting the
binary to varchar...[ convert(varchar(), EncryptByKey(...)) ]. It
seems to work. Will this break one day? The data is normally
accessed through an abstracting UDF. Will this scheme survive?
Thanks,
Bill
.
- Follow-Ups:
- Re: encrypted value storage
- From: Mike C#
- Re: encrypted value storage
- Prev by Date: Re: permissions not working
- Next by Date: Re: encrypted value storage
- Previous by thread: DBReindex
- Next by thread: Re: encrypted value storage
- Index(es):