Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Truncation of long fields when loaded from Oracle database

Has anyone ever had a problem loading long text fields from an Oracle database?

We have a table in an Oracle 10g database with a column that is defined as varchar2 with a size of 600. Only a few of the rows have text data longer than 500 characters but when it is loaded into QlikView the text is truncated to 511 characters. I'm using Windows XP and QlikView 9.00 SR1 but I don't know if the QlikView version has anything to do with the problem.

I've successfully loaded long text strings into QlikView from an Excel spreadsheet with no problems. This truncation problem seems confined to loading from Oracle.

Has anyone seen anything like this?

Thanks for any help.

-Tim Benoit

3 Replies
Not applicable
Author

Yes, I have the same problem at the moment. But I don't know any solution...

prieper
Master II
Master II

Can recall that there was a thread already - think that this might be a problem of the ODBC-driver (=Oracle).

Peter

Not applicable
Author

Hi

I have a similar problem. Have you fixed? how?

thans

luca