Post reply

Encrpting a Image Column in SQL2005

  • March 19, 2009 at 5:39 pm

    #129263

    Hi All

    can anyone help me or suggest how i would go about encrypting a image column within a table for sql2005. I read thru the msdn for encrypting a varchar field which was pretty handy and easy to do but i have not been able to figure out how to do the same for a image field ?

    any help or suggestions would be greatly appreciated..

    Cheers

    Dom

  • March 19, 2009 at 5:57 pm

    #963237

    If you want to encrypt it and know how to do that with VARCHAR maybe just convert it:

    DECLARE @t TABLE (img IMAGE)

    INSERT INTO @t

    SELECT 0x48656c6c6f20576f726c64

    SELECT CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), img))

    FROM @t

    Greets

    Flo

  • March 19, 2009 at 7:38 pm

    #963268

    sensational

    thank you very much 🙂 you have made my weekend !

  • March 20, 2009 at 4:41 am

    #963409

    Pleased to help you. 🙂

    Flo

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

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