topic Re: Problem loading UTF8 from SQL Server in QlikView

Problem loading UTF8 from SQL Server

nicktodd — Wed, 22 Feb 2017 10:32:10 GMT

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

Re: Problem loading UTF8 from SQL Server

mbespartochnyy — Wed, 22 Feb 2017 19:37:58 GMT

Try using this in your SQL Select statement:

SUBSTR(CONVERT(FIELD_NAME, 'US7ASCII', 'UTF8'), 1, 2000) AS FIELD_NAME

I'm not familiar with SQL Server 2008, but this works in Oracle / PLSQL. There might be a similar syntax for SQL Server as well.

Mikhail Bespartochnyy

Re: Problem loading UTF8 from SQL Server

nicktodd — Thu, 23 Feb 2017 13:32:28 GMT

Well after much head scratching it occurred to me that instead of loading from our Dev database I should try our live database - and it worked! Seems like there is an issue in how our Dev environment is set up.