[AccessD] Opening Files from BLOB in SQL Server 2012

[Stuart McLachlan]

That's about what I suggested, except that it was your intermediate code rather than the final 
write that had problems because of the way 97 and before stored text as ASCII while it now 
stores it as Wide.

As soon as you passed chnks through a string variable in your code,  you ran into this 
fundamental difference

-- 
Stuart

On 30 Oct 2015 at 19:42, Jurgen Welz wrote:

> It turns out that you don't need to do the Unicode conversion if you
> write the byte array directly to the file system.  The sample code I
> had from the old knowledgebase article used a string variable but that
> step is unnecessary as is taking fixed size chunks out of the file in
> a loop plus any remainders.