DATABASE LOAD CHANGES LENGTH WHEN SWITCHING TO MEMORY (POSTGRESQL)

[fontesflp]

My text field has a maximum size of 255 characters when loading into qlik's memory. The same field loaded in pgadmin has a longer length.

[fontesflp · Accepted solution]

I solved the problem.
For some reason, when the column is of type TEXT, the qlik LOAD only loads 255 characters.
By changing the type to CHARACTER VARYING(1000), the LOAD loads the complete string

[obmk]

In addition to this solution, the following tip might also be helpful in this context when it's about

"extracting data from TEXT columns having much more than 1000 or 16384 characters inside":

https://community.qlik.com/t5/App-Development/Does-column-length-in-SQL-SF-table-matter-when-reading...

so short

Stefan

[amon]

You saved my life, I had the same issue with the same use case (polyline geometries), works as a charm