Loading binary data, truncated after 255 chars

[ronnycsharp]

Hi,
I need to load data from a table with a binary column.
Its defined as varbinary(max). Its a pdf-document. (300kb-1mb).
The loaded row is truncated after 255 chars.

I ve created a stored proc on the server to split the data into many rows.
But thats a very bad way.

Is there another (better) way to do it?

Thank you.

ps.
I've also seen that I can load 8000 chars but the binary data will be converted to ascii.
And the strings will be truncated.

Regards
Ronny

[martinrybak]

Please try out the types branch. This issue should be fixed.