DataGrip file import bug
When I import data into SQL Server (2017 on Linux) from a file, the first row is alway omitted. This happens with CSV files and text files with semi-colon delimiters. The files do not have header rows. The is an error message complaining about the first field of the first row being blank. In the file import screen, the very first value is always shown as offset to the right.
I have checked the files in in Sublime and TextEdit; there is no extra character at the start of the file. I have manually deleted and reentered the first value, but the problem still occurs.
I am using 10.13.2 (High Sierra) and DataGrip 2017.3.4, JRE: 1.8.0_152.
What is the solution?
请先登录再写评论。
The solution is: open the file in nano or the like. I found the phantom character not displayed in graphical text editors.
Thanks for finding the solution :)
Ngsmith, where did the phantom character come from? Was it inserted by DataGrip? Thanks in advance.