topic Qlikview OLE DB not reading in data from oracle correctly for Japanese Characters in QlikView https://community.qlik.com/t5/QlikView/Qlikview-OLE-DB-not-reading-in-data-from-oracle-correctly-for/m-p/1257147#M397106 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Im connecting to an oracle database using OLE DB connection and getting data through SQL that contains japanese characters. For some reason, qlikview does not read in the data correctly even when i add codepage is 65001(which is utf8) to the connection string. However, when i export the data from the database to a csv separately and then load that csv into qlikview, it is able to read the japanese characters. I've tried with ODBC connection as well and it was able to get 1 japanese character but the rest were still the upside down question marks.</SPAN></P></BODY></HTML> Thu, 23 Feb 2017 18:48:31 GMT 2017-02-23T18:48:31Z Qlikview OLE DB not reading in data from oracle correctly for Japanese Characters https://community.qlik.com/t5/QlikView/Qlikview-OLE-DB-not-reading-in-data-from-oracle-correctly-for/m-p/1257147#M397106 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Im connecting to an oracle database using OLE DB connection and getting data through SQL that contains japanese characters. For some reason, qlikview does not read in the data correctly even when i add codepage is 65001(which is utf8) to the connection string. However, when i export the data from the database to a csv separately and then load that csv into qlikview, it is able to read the japanese characters. I've tried with ODBC connection as well and it was able to get 1 japanese character but the rest were still the upside down question marks.</SPAN></P></BODY></HTML> Thu, 23 Feb 2017 18:48:31 GMT https://community.qlik.com/t5/QlikView/Qlikview-OLE-DB-not-reading-in-data-from-oracle-correctly-for/m-p/1257147#M397106 2017-02-23T18:48:31Z Re: Qlikview OLE DB not reading in data from oracle correctly for Japanese Characters https://community.qlik.com/t5/QlikView/Qlikview-OLE-DB-not-reading-in-data-from-oracle-correctly-for/m-p/1257148#M397107 <HTML><HEAD></HEAD><BODY><P>Figured it out. I was using the Microsoft OLE DB for oracle driver initially and switched it to the Oracle for OLE DB driver (provider=OraOLEDB) that is at the bottom of the list of available driver connections and it works perfectly now. No need for codepages or anything extra.</P></BODY></HTML> Thu, 23 Feb 2017 21:51:08 GMT https://community.qlik.com/t5/QlikView/Qlikview-OLE-DB-not-reading-in-data-from-oracle-correctly-for/m-p/1257148#M397107 2017-02-23T21:51:08Z