Not able to pull more than 1023 characters from a single cloumn

[deepakk]

Hi,

I am pulling data from MySql. The cloumn cookies contains data URL like http/:www.xyz.com/?hf

The maximum size of the field is 2048 varchar . I have pull the data into the QVD. when i am extracting the data for cookies field, I see that only 1023 character has been pulled. i.e if a value for cookies contain 1048 characters it will pull only 1023.

Please le me know if you have any solution for this.

[manishkumar75]

Have you checked len(cookies) ?

[deepakk]

Yes. The length of the cookies varies from 1042, 1100 or 800 but the maximum len the Qlik view is able to pull is just 1023

[rbecher · Accepted solution]

You could check if it's a problem of the ODBC driver. If not, I would suggest to contact support.

[Anonymous]

Don't know if it will help in your database, but I use sometimes this syntax in SQL
cast(FIELD as varchar(2000)) as FIELD

[deepakk]

The Cast function is not working in Qlik View 8.5

[#7]

Don't know if that helps but if there is such a limitation, I would store the column in differents pieces

For example first one as LEFT(FIELD,1023) 'Field_1', Mid(FIELD,1024) 'Field_2'.

In SQL Mid should be substring or something like that.

Then you should have everything in your QVD.

Hope this will helps.

Another solution, if possible is to change the default SQL buffer sometimes we can change it in ODBC or BDE.

Rgds,

Sébastien

[deepakk]

I already tried the first part its not working the second part extract balnk value....

I will try out the second solution...

[Anonymous]

Cast is a database fumction, not QV. Try it in the SQL SELECT, not in LOAD.

[deepakk]

It worked when i Used OLE DB connection instead on ODBC..

Thank you all for your help...