Connection to SQL Server - How to prevent leading space removal
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.