export as CSV from MS SQL Server ignores commas

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)

https://qgis.org

GNU General Public License v2.0

10.61k stars 3.01k forks source link

export as CSV from MS SQL Server ignores commas #30506

Open filipmahieu opened 5 years ago

filipmahieu commented 5 years ago

Describe the bug

How to Reproduce

QGIS and OS versions

Additional context

filipmahieu commented 5 years ago

In QGis 3.4.5, W10. When exporting a layer to CSV a numeric value with a comma (eg fieldtype 'double precision') gives an integer in the CSV. Even when the separator is set to TAB or Semicolon this becomes an integer.

gioman commented 5 years ago

@filipmahieu can you attach sample data?

filipmahieu commented 5 years ago

After further research, it seems this only happens with SQL-Server-data. I give you an sql-script from (a part of) the used data: TestTabelQGis.sql, sql-server 2016-database. 5 columns have non-integer numeric values. Exporting this table in QGis to CSV with as delimiter semicolon gives TestExportUitTabel.csv, which viewed in QGis gives no commas. Test20190619.zip

Pedro-Murteira commented 2 years ago

Still valid on QGIS 3.22.4 and 3.24.0.