Handling Special Characters in xml auto

[fergmj]

I have a table called employees
it has an employeeid, firstname, lastname etc....

I have some data in the lastname column that has special characters -- tildas and such -- for international names.

In Query Analyzer I have:
sp_makewebtask @outputfile = 'c:\temp\myxmlfile.xml',
@query = 'select * from employees for xml auto',
@templatefile = 'c:\temp\template.tpl'

When I run this command, the data comes out like this:

LastName="MARTÃ?N"

when it should be LastName=MARTÍN

Anyone know how I can correct this?

Thanks

fergmj

 

[fergmj]

I found the answer so i though I would post it:

In my template file, I needed to escape the characters that were a problem -- example --

<%EscapeHTML ~'%>

The data coming from the select statement was good -- and I verified it by exporting the data to a .txt file instead of an xml.

 

[gmmastros]

I'm glad you found a solution.

http://technet.microsoft.com/en-us/library/ms180099.aspx

sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL Server 2005 Reporting Services (SSRS).

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom