Click here to Skip to main content
15,896,428 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

Thank you for paying attention,

I have a xml document that I wanna save in sql server 2005, I got the following error:

Msg 9420, Level ..., State ..., Line ...
XML parsing: line ..., character ..., illegal xml character

I guess that, it's because of using middle east characters in it, I have Farsi characters in it for example and I cann't ignore them.

i tried to change collation to arabic_ci_ai and other arabic collations but got no success.

any idea please???
Posted
Comments
Corporal Agarn 10-Oct-11 14:29pm    
When you changed the collation did you change the table or the database? If database the table will need changed if it was already created.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900