How to store byte[] in text field in database and retrieve it

Question

I have a large issue.
I uploaded image and get byte[].
In database I have NVARCHAR(MAX) field and it can't be changed.
What ever I do and save in database I can't get it as image later.
I triedn .ToString() doesn't work.
I have tried this:

private byte[] GetBytes(string str)
        {
            byte[] bytes = new byte[str.Length * sizeof(char)];
            System.Buffer.BlockCopy(str.ToCharArray(), 0, bytes, 0, bytes.Length);
            return bytes;
        }
static string GetString(byte[] bytes)
        {
            char[] chars = new char[bytes.Length / sizeof(char)];
            System.Buffer.BlockCopy(bytes, 0, chars, 0, bytes.Length);
            return new string(chars);
        }

And when I try to put it in RadBinaryImage I get nothing.
This is the error:

 The provided binary data may not be valid image or may contains unknown header

You MIME encode/decode the bytes in and out of the TEXT field. — hometoast
– hometoast, Commented Feb 12, 2013 at 14:58

Kendrick · Accepted Answer · 2013-02-12 15:01:03Z

10

You probably want to encode it, rather than just convert directly.

I've successfully used Radix-64 encoding in the past. There's a C# method for it, but I haven't used it:

Convert.ToBase64String(byteArrayForImage);

http://msdn.microsoft.com/en-us/library/dhx0d524.aspx

Then you can use the reverse conversion to get your byte array:

Convert.FromBase64String(stringFromDB)

answered Feb 12, 2013 at 15:01

Kendrick

3,7871 gold badge25 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to store byte[] in text field in database and retrieve it

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related