topic Re: SQL truncates text data in QlikView

SQL truncates text data

Wed, 18 May 2011 17:01:19 GMT

HI, Have strange situation: some long strings are truncated by the Qlikview sql. Some of them after 430 char, some after 500 char, randomly. Any ideas?

Re: SQL truncates text data

johnw — Thu, 19 May 2011 00:04:29 GMT

It's possible that QlikView is hitting characters that it interprets as end of line or something. I don't actually know if it does that, mind you. If that IS a problem, a way around it would probably be to use the verbatim flag.

SET Verbatim=1;
LOAD your data
FROM your source;
SET Verbatim=0;

I suspect that isn't it, though, as the help text only indicates that Verbatim keeps QlikView from trimming spaces, and I doubt funny characters are the problem anyway. It's just my only guess right now.

Re: SQL truncates text data

Thu, 19 May 2011 14:23:46 GMT

There no special characters. This is what I suspected also. I went to V10 and all is working fine. It is another bug in v9. Thank you