problem in varbinary(50) to byte[]

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Dear all
I have problem when accessing varbinary(50) value in byte[].

I'm reading value from MS-SQL DB as

C#

byte[] temp= (byte[]) cmd.ExecuteScalor();

Stored value in DB column is 0x617A (Hex ASCII of 'az').

But temp variable contains 13 bytes instead of 2.

Code used to insert value in DB

C#

cmd.Command="INSERT INTO table1(columns1) VALUES (CAST('az' as varbinary))";
return cmd.ExecuteNonQuery();

Posted 28-Jan-15 6:52am

DoingWork

Updated 28-Jan-15 7:25am

v3

Add a Solution

Comments

PIEBALDconsult 28-Jan-15 13:00pm

Are you sure there are only two bytes in the database? I suspect the value got stored wrong. Can you use Improve question to show the code used to store the data?

DoingWork 28-Jan-15 13:23pm

Yes I'm sure that there are only two bytes. I have verified it in Management studio too (Query editor + executor part of SQL server).

Code used to insert value in DB
cmd.Command="INSERT INTO table1(columns1) VALUES (CAST('az' as varbinary))";
return cmd.ExecuteNonQuery();

PIEBALDconsult 28-Jan-15 13:39pm

I note that System.Byte[] contains thirteen characters.

DoingWork 28-Jan-15 13:57pm

hmmm..... Why it contains "System.Byte[]" instead of actual data (0x617A)???

PIEBALDconsult 28-Jan-15 14:07pm

It might not, but a ToString of a byte[] array will.
I wonder why you are storing a string in a varbinary rather than a varchar.
I also wonder what the actual query is you are executing.
And I wonder whether or not CAST(columns1 AS VARCHAR) will help you.

DoingWork 28-Jan-15 14:18pm

My requirement is to put data in varbinary typed column so i'm not using varchar.

Query to retrieve value
cmd.Command= "SELECT Column1 FROM table1 WHERE Column2 = 2" ;

PIEBALDconsult 28-Jan-15 14:25pm

Well, I suspect everything is working correctly, but you may be interpreting the results wrong. What do you do with the byte[] after you retrieve it?

DoingWork 28-Jan-15 14:32pm

Only checking temp array that why 13 bytes instead of 2.
byte[] temp = (byte[])cmd.ExecuteScalor();

PIEBALDconsult 28-Jan-15 14:39pm

How do you check it? In the debugger?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)