Getting Binary/Image Type as a Buffer about node-sqlserver-v8 HOT 8 CLOSED

does something like below force it to return a buffer - for a varbinary column it should not attempt to map to a string, but it probably drops to string by default, what is the actual column definition.

select cast(buffer_param as varbinary(1000)) from [dbo].[buffer_param_test] as raw_data

from node-sqlserver-v8.

the above is working nicely but only for 1000 ..... if using (3000)+ or (max) it stops trying to buffer and just spits out the string? how to make this work for data larger that 2000?

from node-sqlserver-v8.

from node-sqlserver-v8.

Looking at the driver code looks like I will have to take a look at this. I don't think it currently handles larger than 2k binary columns as you have discovered. I will try to get a fix out as soon as possible in coming days.

from node-sqlserver-v8.

the source column type is "image". With the cast it was successfully converting it to the varbinary type.

No rush on this now I was able to do the conversion in SQL first with this:

SET ARITHABORT ON
SELECT
ReportID AS ReportID,
CAST(N'' AS XML).value('xs:base64Binary(xs:hexBinary(sql:column("PDFData")))', 'VARCHAR(MAX)') AS PDFEncoded
FROM (
SELECT RPT.ReportID,
CONVERT(VARBINARY(max),RPT.PDFImage) AS 'PDFData'
FROM Reports AS RPT
WHERE RPT.ReportID='00001'
) AS rtp_temp

Thanks,
Jeff

from node-sqlserver-v8.

I found cause of this issue it will be fixed in next version. Thanks for showing me how to reproduce it.

from node-sqlserver-v8.

this is now fixed on latest version 0.4.5

from node-sqlserver-v8.

Thank you for your quick responses on the initial trouble shooting and continued support on this module.

Thanks,
Jeff

from node-sqlserver-v8.