SQL Binary and C# byte[]

Hello,

I am having a problem with a binary field in SQL Server.

I need to be able to run some queries through a C# Application over 2 databases.

So I am basically reading in a binary data field and convert it to a byte[] datatype and then storing it on a table in a different database as a foreign key value.

However, when I run the query, the 2 values of binary data don't match and the query doesn't return any results...

I am reading the result set of the query in a DataSet from which I create a DataReader in order to be able to read and convert the binary data value.

byte[] uuid = (byte[])DataReader["uuid"];

After that I store it in a database by the use of an SQL Command object and a parameter of binary[] type.

After all this I am not able to associate records by the use of this field and when i run a simple Select command on sql server on both tables, the coded values are the same except from the last 2 digits...

Has anyone has a similar problem, or know of another way to do this?

Thanks in advance...

TedManowar

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jan Montano19y ago
Hi Ted,

Could you give an example? I need to know...
First, the value of uuid in the db.
Second, the value of byte[] uuid after getting it from the db.
Third, the value when you put it back again in the db.

and also pls put the partial code for the 3 items i mentioned. Thanks. :)