topic Re: Is there a limit on String Field character size? in Move to Qlik Cloud Analytics

Is there a limit on String Field character size?

Mary-Joicelin — Tue, 27 Jan 2026 10:45:26 GMT

Dear Team,

We are using Qlik SaaS (BYOK). When I was loading the data in a qvd file, from S3 data lake, using Athena Connector.

I have noticed that a string field is broken in the qvd file. i.e. If the string is longer, it has loaded only up to 254 characters.

Is there a limit on number of characters in a field's value? If yes, is there a workaround to load the whole value of the filed?

Re: Is there a limit on String Field character size?

Albert_Candelario — Wed, 22 Mar 2023 20:12:19 GMT

Hello @Mary-Joicelin ,

This reminds me of this:

https://community.qlik.com/t5/Official-Support-Articles/MongoDB-connector-limits-text-field-to-255-characters/ta-p/1710303

Also for reference:

https://exasol.my.site.com/s/article/String-length-exceeds-limit-of-255-characters-in-AWS-ATHENA?language=en_US

I hope this give a hint.

Cheers,

Albert

Re: Is there a limit on String Field character size?

Mary-Joicelin — Thu, 23 Mar 2023 11:04:27 GMT

Thanks Albert! Indeed, the parameter set to 255. I will change the stringColumnLegnth.

Thanks a lot! Much appreciated!

Warm regards

Mary Joicelin J

Re: Is there a limit on String Field character size?

Albert_Candelario — Thu, 23 Mar 2023 13:20:00 GMT

Excellent @Mary-Joicelin

Cheers,

Albert

Re: Is there a limit on String Field character size?

oli_hardy — Fri, 08 Sep 2023 13:06:38 GMT

Hi @Albert_Candelario

Are you aware of any restriction or setting options regarding field length by fetching data over the data gateway?
In the connector setting (postgressql) the max field length is the default value of 4096. But only a max 255 characters comes through.

Re: Is there a limit on String Field character size?

Albert_Candelario — Sun, 08 Oct 2023 13:20:09 GMT

Hello @oli_hardy,

Is this still an issue for you? If yes, let's open a new thread and we will have a look and see this with the rest of the Community.

Cheers,

Albert

Re: Is there a limit on String Field character size?

oli_hardy — Mon, 09 Oct 2023 07:34:48 GMT

Hi Albert.

Thanks for your response and your offering for help.

Fortunately my issue could be resolved. This article helped me to find a way to fetch more characters ( https://community.qlik.com/t5/App-Development/Does-column-length-in-SQL-SF-table-matter-when-reading-data-into/m-p/2040442/highlight/true#M85726)

I had to adjust some settings in the connector: disable "enable bulk reader" and setting advanced parameter: useBulkReader to false

Re: Is there a limit on String Field character size?

Albert_Candelario — Tue, 10 Oct 2023 05:18:48 GMT

Great @oli_hardy !