Qlik Connectors: How to import strings longer than 255 characters

[Andrea_Bertazzo]

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.

 

Environment

• Qlik Connectors
• Built-in Connectors Qlik Sense Enterprise on Windows November 2024 and later

[Giovanni_Civardi]

hi @Andrea_Bertazzo ,

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]

@Giovanni_Civardi Yes, this the max possible value