Using MS SQL Binary Data Type

[Shup]

I want to use varBinary to store some values but I'm a little confused on choosing the correct size for the data type. I'm not use to dealing with binary.

I think I understand that Binary is stored as bytes...? If, for example, I have a string that is going to be a maximum of 30 characters long, I would use the nVarChar data type with a size of 30. So if I am storing a password that is no more then 30 characters long (from an array), and saving it as varBinary, would I choose 30 as the size for the binary data type?

Also, I'm looking for a very good buffer to read binary data from the database, are there any excellent examples of a buffer I could use when reading the binary data from the database? Should I also use the buffer when saving data to the database?

Thanks in advance.

[joleary]

Have you found your answer to this, Shup?

I have a similar need of inserting/selecting binary data from a SQL Server 2000 table.

I'd appreciate any insight you may have come across.

jim

[Krzemo]

Post your requirements for taht data. I don't know what a problem is. I'm using binary data in SQL2000 with no problem at all. If U want to store passwords in db then I think it should be avoided. If U cannot live without it :rolleyes: U can use ittaking into account difference between UNICODE string length and number of bytes it takes to store it (and if it is a password than is should be hashed). So what your problem really is? What programming language U prefer to use?

Best regards,
Krzemo.

[joleary]

Krzemo-

Thank you for your interest in my problem.

I have created a new thread with the details entitled:

"Multiple-step OLE DB ... errors" on ADO PutValue (http://www.codeguru.com/forum/showthread.php?t=414076)

I welcome any thoughts you may have about my issue, which has me completely blocked.

Regards,

jim