Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
artfer
Contributor
Contributor

Oracle Varchar(byte) to varchar(char)

Hello,

I'm trying to upload data through csv's to a oracle db. These files come from an export of another db with the exactly the same schema. For some reason, when importing I get errors saying "ORA-12899: value too large for column". This is confusing since it came from the same schema... I've already changed the enconding to "windows-1252", and tried the ISO and UTF8. Same problem, but the windows encoding actually has readble text. So my conclusion is that, Talend reads varchar2 as type byte instead of char. Problem is, I don't know how to fix that or how to do a workaround. Can I get some help please? L

imiting the string is not an option.

Thanks in advance

Labels (3)
0 Replies