SQL Server Developer Center > SQL Server Forums > SQL Server XML > odbc export from mssql, umlaut problems after export
Ask a questionAsk a question
 

Questionodbc export from mssql, umlaut problems after export

  • Monday, October 26, 2009 10:01 AMSandsturm Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    hi all

    I have following problem:
    MSSQL 2005 database with Collation Latin1_General_CI_AS. Umlaut Data in tables are written  correct. I'm doing an export from this data to an xml file with a visual basic script, taking an odbc connection with an sql user. After exporting data, the Umlauts ä,ö,ü,é... are written as ç,é,ü.. in the xml file.
    I don't know where I have to define a conversion or collation or something for this export...

    Can someone help me?

    Thanks a lot