When accessing a table from our MSSQL Server via MapInfo, none of the fields contain trailing white spaces, the same holds true when exported to CSV via MapInfo.
However, when exporting the same table from Management Studio, all the fields have quite a few consistent amount of trailing white spaces, this is causing issues when using the tables in Spectrum.
I have tried doing a field update with the RTrim function in MapInfo but nothing changes.
Any ideas as to why this happens?
PS: Only certain tables exhibit this behaviour.