strange characters in sql server !!!

• christophe.bernard 47659

  Ten Centuries

  Points: 1169

  More actions

  January 14, 2011 at 6:22 am

  #230395

  Hi,

  I'm a beginner with t sql and sql server 2005

  here is it my problem ..

  I have a web page in c# who contains an input file, users can select a file in .txt and push save

  button .

  In the save options, i transform the content of the file INTO a xml file

  If it's success, i fire a store procedure who receive this xml file in parameters

  but when i execute all, i receive this message : Conversion of one or more characters from XML to target collation impossible

  If i copy paste the xml generate as this :

  <Items>

  <Item>

  <Name> ...</Name>

  ........

  </Item>

  </Items>

  if i looks all string between name i see that some characters as transform into another !!!!!!

  sample : é => become ...look like in attachement waouhhh

  i use replace and change bad characters into é and run my store procedure that works !

  what is the problem ?!

  any idea or sample

  thanks

  christophe

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  January 14, 2011 at 8:42 am

  #1273596

  Is the problem already in the XML files?

  I believe the problem is to do with XML serialization/de-serialization in .NET

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---