Datagrip csv export modifies special characters äöü, etc.
Answered
This is how the query correctly spits out the data when running it within DataGrip:
This is how it looks like in the csv file:
This is how my file encoding looks like:
I am at a loss and couldn't find anything on Google on how to fix this. I am quite frustrated. What is the issue?
Please sign in to leave a comment.
Hello Jonas,
Sorry for slow reply.
When you export data from a table IDE will always create a file with UTF-8 encoding. Here is related issue: https://youtrack.jetbrains.com/issue/DBE-1603
But probably your problem is not encoding of created file because UTF-8 is fine for für. I guess you open file in Excel using File | Open which doesn't work properly for CSV files.
Here is what I get:
You need to use File | Import and specify UTF-8 encoding