Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
FrederikV
Contributor
Contributor

Connection to SQL Server - How to prevent leading space removal

Hello,

We are using a SQL server. Some data contain leading spaces.

When I'm using the Microsoft SQL Server connector, or the ODBC connector, these leading spaces are removed. This is very annoying as we cannot distinguish data with leading spaces and data without leading space. For example, the article "  351634" and the article "351634" are considered as being the same article, which is not true.

I don't see any option to prevent this behavior, neither in the app nor in the QMC.

We also tried various drivers, without success.

What could we try?

Thanks in advance for your help

0 Replies