QlikView sql load converting text to hex

chriswain2 — Fri, 16 Sep 2016 09:22:01 GMT

I had a load script working fine before a migration from 11.2 sr 2 to sr 13.

Now, just on one load script from a particular database the initial SQL is converting some but not all of the fields from text into hexadecimal. The SQL is just select * and in the load script I have tried set Verbatim = 1, putting text() around the field etc, but it seems it has already changed it in the SQL load.

I can run the same query, select *, in excel and it brings it back in normal text format.

Is it a bug in 11.2 sr 13?

I can get round it by breaking up the hex field and mapping each pair of hex digits back to its text value, but I am looking for a setting which will just fix it.

An example original value LEGGJ is loaded by QlikView as D3C5C7C7D14040404040 i.e. D3 = L etc

Re: QlikView sql load converting text to hex

chriswain2 — Mon, 31 Oct 2016 08:21:53 GMT

It turned out that on the ODBC connection there is a tick box "Convert binary data (CCSID 65535) to text" which was not ticked. We had moved to a new server and not set up the connection exactly the same. As we had upgraded our version of QlikView at the same time it confused the issue.

Picture attached.

topic QlikView sql load converting text to hex in QlikView

QlikView sql load converting text to hex

Re: QlikView sql load converting text to hex