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?