article Qlik Connectors: How to import strings longer than 255 characters in Official Support Articles

Qlik Connectors: How to import strings longer than 255 characters

Andrea_Bertazzo — Thu, 13 Mar 2025 14:56:32 GMT

Recent versions of Qlik connectors have an out-of-the-box value of 255 for their DefaultStringColumnLength setting.

This means that, by default, any strings containing more than 255 characters is cut when imported from the database.

To import longer strings, specify a higher value for DefaultStringColumnLength.

This can be done in the connection definition and the Advanced Properties, as shown in the example below.

The maximum value that can be set is 2,147,483,647.

Giovanni_Civardi — Wed, 10 Dec 2025 13:36:21 GMT

the screenshot you provided shows a value of 4096 DefaultStringColumnLength.

can you confirm that the accepted valures are:
"The maximum value that can be set is 2,147,483,647."

thank you.

Andrea_Bertazzo — Fri, 12 Dec 2025 14:44:37 GMT

@Giovanni_Civardi Yes, this the max possible value