How to import strings longer than 255 characters in Qlik

14 March 2025

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

For information about Qlik™, click here: qlik.com.
For specific and specialized solutions from QQinfo, click here: QQsolutions.
In order to be in touch with the latest news in the field, unique solutions explained, but also with our personal perspectives regarding the world of management, data and analytics, click here: QQblog !

Leave a Reply Cancel reply

Marius Teler, Business Developer – NEMO EXPRESS

“Only capitalizing on the hourly analysis proposed by QQinfo allowed us to identify situations in which the hourly planning of the activities of our courier teams could be improved, leading to an increase in the efficiency of our field resources by at least 20 percent, so we have already amortized the money invested in the Qlik™ platform in the first 3 months, practically already obtaining a higher ROI than the one estimated in the initial analysis.”

Marius Teler

NEMO EXPRESS

Dragoș Druga – CFO, Jean Christof E&P Services Romania

We chose QQinfo because they demonstrated to us their dual ability, on one hand to master the Qlik™ platform and on the other hand to understand in a few words and to offer concrete solutions, with alternatives, to our real business needs. financial and operational.

Our results obtained after the first delivered project: 95% decrease in calculation time in cash flow projections, simultaneously with an increase in accuracy of at least 3 times.

After the delivery of the first projects, we found, with joy, that we have in QQinfo a reliable partner, which responded promptly to our punctual requests for support, which is why we decided to extend the stand-by support service contract. In the near future we will expand the collaboration with new projects as soon as our new data sources will offer us new fronts of work.

Dragoș Druga

Jean Christof E&P Services Romania

Dan Șerbănescu, Director General – NEMO EXPRESS

“We decided to choose QQinfo and Qlik™ mainly because of QQinfo consultants’ abilities to quickly understand our company’s needs and to create a coherent, multi-dimensional and easy-to-use system of analysis specific to our industry, going exclusively from 2 meetings with NEMO management.

The results amazed us through the wealth of analytics prospects, beyond the major leap of performance and consistency.”

Dan Șerbănescu

NEMO EXPRESS

Mihai Pătrașcu – Founder & CEO, evoMAG

It’s comforting to work with a BI team that first understands your needs, offers you viable alternatives and then runs the agreed solution on time (and often more!). This is the feeling that I have when I work with the QQinfo Team!

Mihai Pătrașcu

evoMAG

Cornel Paraschiv – AUTOKLASS CENTER

“We have approached the QQinfo team to implement reporting and analysis solutions to improve the performance of AUTOKLASS, from the express desire to automate some processes. Later, we decided to extend the reporting system and management analysis from the need to give decision makers time to quickly find better, faster solutions by accessing data at a Qlik™ distance.

The results have not been delayed to occur, even faster than we had predicted. “

Cornel Paraschiv

AUTOKLASS CENTER

Adrian Dima, Co-Founder, General Manager – Kognitive Manufacturing Tech SRL

During the development of the KFactory platform, the need to integrate a business intelligence solution appeared. After a long search, we had the pleasure of meeting the QQInfo team, a team that has proven its professionalism by supporting the accelerated adoption of Qlik Sense™ in our platform. Following the conclusion of the partnership with QQInfo, both parts won, but especially our customers.

Adrian Dima

S.C. Kognitive Manufacturing Tech SRL

Mihai Irimia, General Manager – Patiseria Tineretului SRL

QQinfo has provided us with a level of IT services that we have simply never encountered before. They helped us promptly with solutions to all the problems we encountered, although we did not expect them to find concrete solutions so quickly (many times they found and implemented the solution right away, during the discussion!). They took our needs on the fly and, without us writing any specifications, they created all the functionalities we asked for, but especially the ones we needed, even if we hadn’t realized them yet! They have everything you need: vision, understanding, ability, efficiency … and a little bit of humor !

Mihai Irimia

Patiseria Tineretului SRL

Cristian Chițu, Founder & CEO – Patiseria Tineretului SRL

QQinfo have done everything they promised and even more! And together they use the coolest possible platforms: Qlik™ & AirTable ! Forget Excel completely !

Cristian Chițu

Patiseria Tineretului SRL

Nicu Sofian, IT Director – Maspex Romania SRL

Beyond solving everyday problems, less often or not, depending on how we needed it, we appreciated the quick, involved, and innovative reaction they had to the QQinfo team when they faced a critical situation. Not only did they promptly assist us in solving all the post-disaster recovery needs related to the BI platform, but they also came up with valuable solutions through which we managed to recover extremely important details from the BI area to reconstruct the data from the transactional systems.

Nicu Sofian

Maspex Romania SRL

Valentin Mitrea – General Director, Smart Vending

It’s a real pleasure to work with a team of professionals who have taken all your worries about developing managerial analyzes. Now, sales, profitability or stock information are really at hand.

Analyzes developed by QQinfoteam have combined our previous computing and analysis models with their know-how, so we have now cut 90% of search and recalculation time for both me and our entire management team, central and regional government. We have more time for the real analysis and decision-making, a much broader perspective on the reality of our business, and I have also gained time for my family!

And since “lust comes eating”, after the first iterations, we contracted a regular BI outsourcing service: one day a week, one member of the QQinfo team is standing next to me to add to the Qlik™ – based management analysis system the new perspectives I need.

Following the new QQinfo analysis perspectives, we have made important decisions about spending control, which has led to a 50% drop. At the same time, following the reporting system built by QQinfo, we managed to track customer developments, generating revenue growth and averting possible revenue cuts. The result, of course, maximizing profits and, last but not least, access to otherwise impossible information.

Personally, now I consider that the BI built with QQinfo is indispensable for a mature IMM that wants to maintain a steady and solid profit growth.

Valentin Mitrea

Smart Vending

Tudor Manea – VP Human Resources and Technology, Dante International SA

We have always benefited from prompt delivery of the required products and services and quality support too, both during the implementation and post-development. Moreover, QQinfo’s advice and their solutions for some situations allowed us to identify and/or overcome significant technical obstacles, thus achieving the objectives of streamlining management analyzes and support systems decisions.

Tudor Manea

Dante International SA

Laurențiu Gheorghiu – Advertising Traffic Manager, ProTV

We have been able to highlight, through analyzes made in Qlik™, viewing and buying habits, smoother segments of viewers and consumers and from here, adjusting our trade and program policies where needed. Operational net result at the end of the day: an increase in efficiency by 150%.

Laurențiu Gheorghiu

ProTV

Adrian Oprea – Project Manager, Tuborg

For QQinfo Team: The greatest artists and thinkers are simplifiers.

Adrian Oprea

Tuborg