resulting xml in the following way

Question

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

Answer 1

showing up as "character�����" when i serialize to xml.

Hello,

 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.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing