Re: XML and Pound (£) Symbol

This is most likely an encoding issue...

What encoding is the pound sign in the XML document? And how do you pass it
to SQL Server?

As always, a minimal repro would be useful.

Thanks
Michael

"Derek" <Derek@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8A56B5C6-8A8C-401D-9247-F1B54C7B2A5F@xxxxxxxxxxxxxxxx
We have an application having problems communicating with a SQL Server
database via XML.

The application is a Microsoft Word VBA applicatino using Microsoft SML,
v2.6 to create XML documents to hand to the server.
It is connecting to SQL Server 2000.

It has been operating fine for 18 months.

Last week we moved SQL Server to a new Server. The only significant
change
was that the server is running Windows Server 2003 whereas the old server
was
running Windows Server 2000.

The passing of the XML document back to the SQL Server database is now
crashing whenever the user has used the £ symbol.

I haven't been able to find anything on the web about this. Suggestions
welcome.

Thanks
Derek


.

Relevant Pages

  • Re: OleDbDataReader and TEXT field
    ... On SQL Server I have a table that is used to store files in TEXT data ... When reading it as characters, .NET will do its best to convert the text in that field to Unicode characters. ... Problem is, depending on the encoding configured at the server and the actual contents of the column, this might fail. ... You might get lucky if the server uses an encoding that happens to map all the characters in the range U+0000 - U+00FF to the same byte values and back, or if you can tell it to use that encoding for the column. ...
    (microsoft.public.dotnet.framework)
  • Re: Mail Subject gets chopped
    ... Our server is running Active Directory and SQL Server 2000 Enterprise. ... Sounds like a unicode encoding issue. ... MailMessage email = new MailMessage(fcn, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: how do I post XML from an ASP.NET app to another web applicati
    ... does not naturally support post as a XMLDocument. ... to post XML document to a remote url endpoint by using javascript + XMLHTTP ... Would you provide some more info on what the target server application ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Loading XML Data into SQL Server remotely - Best approach?
    ... Bulkload doesn't go over http, but I would suggest it is the best means for ... loading this data into the server. ... > migrate numerous MS Access data databases into SQL server 200 SP3. ... > into a single XML document via VB script and move the new XML document ...
    (microsoft.public.sqlserver.xml)
  • Re: SQLServer CE Files
    ... SQL Server CE can be seen as a .sdf monolithical file with a .DLL ... create an XML document -on the filesystem- by translating ... folder to be visible to Activesync. ...
    (microsoft.public.dotnet.framework.compactframework)
Loading