Incorrect characters (loading from database)

[hajastek]

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.

[hajastek]

Do you have any idea what can cause this issue?

Thanks a lot.

[Anonymous]

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

If you use OLEDB already, I have no idea.

[hajastek]

Unfortunately I am already using OLEDB connection.

[Anonymous]

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.

[PrashantSangle]

Hi,

There is one function convert().

Just check it, might be helpful to you.

Regards

[hajastek]

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?

[hajastek]

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

[hajastek]

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..