topic Re: Incorrect characters (loading from database) in QlikView

Incorrect characters (loading from database)

hajastek — Fri, 27 Mar 2015 21:32:17 GMT

Hi guys,

I am loading data from Microsoft SQL server database. It has collation set to "Slovak_CI_AS", which is correct one, but when I am trying load data from this database into the QlikView, some of the characters are loaded incorrectly. For example 'c' instead of 'č', 's' instead of 'š' ...

But if I am using the same select statement in SQL management studio, all characters are correct.

Re: Incorrect characters (loading from database)

hajastek — Sun, 29 Mar 2015 15:38:06 GMT

Do you have any idea what can cause this issue?

Thanks a lot.

Re: Incorrect characters (loading from database)

Anonymous — Sun, 29 Mar 2015 19:52:59 GMT

If you use ODBC connection, try to switch to OLEDB.

If you use OLEDB already, I have no idea.

Re: Incorrect characters (loading from database)

hajastek — Mon, 30 Mar 2015 07:00:33 GMT

Unfortunately I am already using OLEDB connection.

Re: Incorrect characters (loading from database)

Anonymous — Mon, 30 Mar 2015 12:43:21 GMT

I assume that it's not a Windows setting problem, most likely you use the same characters in all your Windows applications.

If I were you, I'd submit a support case in this situation.

Re: Incorrect characters (loading from database)

PrashantSangle — Mon, 30 Mar 2015 12:57:48 GMT

Hi,

There is one function convert().

Just check it, might be helpful to you.

Regards

Re: Incorrect characters (loading from database)

hajastek — Mon, 30 Mar 2015 15:02:17 GMT

I figured, that all other databases in this SQL server has a different collation as this particular one, which I am loading data from. Might this cause a problem in case I have selected ( in "Connection setting") the only one database?

Re: Incorrect characters (loading from database)

hajastek — Mon, 30 Mar 2015 15:03:43 GMT

Thanks for you advice, but I already tried some conversion function..

Re: Incorrect characters (loading from database)

hajastek — Sat, 11 Apr 2015 13:59:48 GMT

I fixed it by using different OLE DB provider, SQL Server Native Client 11.0 instead of Microsoft OLED DB Provider for SQL Server. All charachters are loaded correctly now..

Anyway it is always unclear for me why Microsoft OLED DB Provider for SQL Server did not work correctly..