Strang value when loading from ODBC table!!

[#1]

HI,

I am loading data from ODBC table and one of the fields is the State.

When I load it to Qlikview it transulate the text to a strang value..such as GA is showing as C6D340!!

Anybody knows what type of value is that ?? Hex? Binary..and how to fix the transulation?

Thanks

[stephencredmond]

Hi,

Looks like some sort of encoded value.  What kind of database is it?  Is there an option in the odbc setup to handle encoded vales?

Regards,

Stephen

[#3 · Accepted solution]

Well, I just found out how to do it.

I used the follwing in my query:

CAST(F.ALADDS AS CHAR(20) CCSID 37)AS ShpToState,

where F.ALADDS is the filed needed to be fixed.