My database is in PostgreSQL and I use Postgre ODBC Driver to load data to my QlikView in Windows 2003
Recently, we changed OS from Windows 2003 Server to Windows 2012 Server and I find a such problem: some information doesn't get in QlikView. For example:
New OS Windows 2012
Code
Client
Id
88b1001a4be9fee011df2b483bd16eb9
2083485b393a34fe11e3b4af231b5d9d
Client3
93ff001a4be9fee011dfe6546bac4ea9
Client4
a5fa001a4be9fee211df528975548601
Old OS Windows 2003
Code
Client
Id
A1832
Client1
\x88b1001a4be9fee011df2b483bd16eb9
AB1398
Client2
\x2083485b393a34fe11e3b4af231b5d9d
1890
Client3
\x93ff001a4be9fee011dfe6546bac4ea9
1865
Client4
\xa5fa001a4be9fee211df528975548601
As you can see, some data from Client and all data from Code doesn't get in QlikView in Windows 2012.
I try to use different version of Postgre ODBC Driver, I try to use and Unicode and ANSI, but the same.
However, when I loaded data in Excel, all data got in Excel file