2 Replies Latest reply: Feb 23, 2017 8:32 AM by Nick Todd RSS

    Problem loading UTF8 from SQL Server

    Nick Todd

      I'm loading data from a SQL Server 2008 database that contains UTF8  but the data is not displayed correctly in Qlikview

       

      For example the word Europe’s (with a single closed quote and not an apostrophe)

       

      is shown as

       

      Europe’s

       

      when I load into Qlikview via OLE DB.

       

      I've also tried the QvODBCConnectorPackage with the same result.

       

      Any suggestions?

       

      Thanks