Post reply

sql server 2005 encryption-getting around the 8000 byte limit

  • March 4, 2009 at 1:54 pm

    #197670

    Is there a way to break up the plain text and encrypt it in chunks to get around the 8000 byte encryption limit? Ideally I would break it up encrypt it and store it all the pieces in one record, using some sort of delimited, and pull the encrypted chunks back out and decrypt them. Running in an asp.net application. I understand that the varbinary(max) field will only allow up to 2^31 -1 bytes. But the 8000 byte limit is a wee bit too small for my purposes.

  • March 5, 2009 at 10:53 am

    #954216

    Why not encrypt at the ASP.NET application and store as VARBINARY(MAX)? That's a much simpler choice than trying to break up, separately encrypt, and store and then the reverse.

    K. Brian Kelley
    @kbriankelley

  • March 9, 2009 at 9:27 am

    #956115

    I probably will. One last question: Does the sql encryption take in 8000 bytes to be encrypted, or is the limit 8000 bytes encrypted output?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply