thanks for your reply.
is there any way to achieve this in SQL Server or any other tool to covert encoding of xmls grammatically.,
 some guys  advised me to upgrade from SQL server 2008 to SQL Server 2012 or above , that will solve the purpose.
regards,

Imran