Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Binary to base64 for xml explicit truncation

Author  Topic  ftsoft Starting Member 22 Posts Posted - 2012-02-02 : 09:46:59 I have the following sp SELECT 1 as Tag, NULL as Parent, Patient.ptn_signature as [ptn_signature!1!!Element] FROM E01 INNER JOIN Patient ON E01.pk_E01 = Patient.pk_E01 WHERE E01.E01_01 = '20111068' FOR XML Explicit, Binary base64 which returns a 12000 or so byte string from a 9000 byte binary column when running the sp independently, but when I use Reader in c#, the string is truncated to what appears to be the 8192 magic number (no end tag). I am using a c# string which should easily handle this so I'm where the extra bytes have gone? Thanks. Frank