Saturday, February 04, 2012 11:18 AM
hi,am converting binary data to char but am getting some special characters
select colname from finaltbl
for xml auto
the o/p has to be "character"
but in xml Found special character showing up as "character�����" when i serialize to xml.
why it is displaying like that ,any solution to rectify that
Sunday, February 05, 2012 8:39 AM
showing up as "character�����" when i serialize to xml.
That's the normal XML encoding of binary data. If you don't want to binary encoded data you have to convert the binaries into an other data type like varchar.
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
- Marked As Answer by KJian_ Friday, February 10, 2012 3:23 AM