Binary data corruption

Question

User-1350516731 posted

Hello all!

I'm trying to store in SQL Server 2017 binary value from C# bytes array. 

I have store it in BINARY field ContosoField via SqlTypes.SqlBinary parameter execution. Then, I want to get back my byte[] array using this: (byte[])ContosoFieldValue but I see another value in result. How to correctly store byte[] in SQL Server storage and get it back into byte[] in condition?

Thank you.

Answer 1

User475983607 posted

Share your code if you need help debugging. Or post sample code that reproduces the behavior.

Answer 2

User1724605321 posted

Hi Alex ,

(byte[])ContosoFieldValue but I see another value in result.

If the sizes of the column data entries vary considerably , use varbinary . What is the problem when convert to byte array with (byte[]) ?

Best Regards,

Nan Yu