none
Euro symbol issue in CP850

    Question

  • We are in US using code page 437 (chcp at command prompt returns 437). We have a 3rd party accounting platform with back-end SQL database that we recently migrated from SQL 2005 to 2008 R2. After changing compatibility level to 100, the vendor required us to change collation (using vendor supplied scripting packaged as an executable) from the SQL default to SQL_Latin1_General_Cp850_BIN.

    Now, after collation change, in the vendor platform client program the euro symbol displays as a ? instead of €

    The vendor says this is a "known MSS issue" but I can't find anything to indicate this except way back with SQL 2000 and 850 not yet supporting the euro symbol.

    Can anybody tell me why this might be happening? (I am not an SQL professional)

    Thanks,

    Joan

    Wednesday, July 24, 2013 7:15 PM

Answers

All replies