SQL Server Import cannot convert string to number when importing CSV on Ubuntu Linux 20.04

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.

https://learn.microsoft.com/sql/azure-data-studio

MIT License

7.56k stars 900 forks source link

SQL Server Import cannot convert string to number when importing CSV on Ubuntu Linux 20.04 #14181

Open vektor8891 opened 3 years ago

vektor8891 commented 3 years ago

Azure Data Studio Version: 1.25.2
OS: Ubuntu Linux 20.04

Steps to Reproduce:

Create a CSV file with the following content:
```
col1,col2
0.2,0
0.1,1
1.3,0
```
Load file using SQL Server Import
Use default data type settings for both columns (decimal(2,1) and bit)
Click Import data at the last step.

You should receive an error:

kép

Note:

This error can be easily fixed by setting the data type to e.g char(10)

kenvanhyning commented 3 years ago

Looks like this isn't going to make April either. Moving this to May.