Post reply

XML parsing: line 1, character 38, unable to switch the encoding

  • December 6, 2007 at 10:04 am

    #179756

    I have a merge replication set up with 100s of subscribers sending data to a publisher (only one way, think publisher as a repository, exchangetype is 1). Subscribers are of sql server 2000 and publisher is 2005.

    Now, i have an article of which the datatype of one column is ntext at subscriber and xml at publisher. i am getting the error message "XML parsing: line 1, character 38, unable to switch the encoding", while sending the data to the publisher.

    Can anyone help me on this???

    :w00t:

    Otherwise, please advice a method to replicate ntext data to an xml publisher??????

  • February 27, 2008 at 5:33 am

    #782444

    Hi All,

    i know its being long time... I resolved the issue. This is an update to all...

    For passing an ntext (2000) value to an xml datatype(2005), there needs to be an encoding done to the string. to accept the string as xml, it should be utf-16. earlier it was utf-8. i changed the same and its working!!!

  • January 13, 2009 at 9:42 pm

    #926367

    great, thanks. its working...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply