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?

1 comment
Comment actions Permalink

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

0

Please sign in to leave a comment.