Exporting from SQL Server into CSV files with ISO-8859-15 encoding

Question

I am trying to export a SQL Server database into CSV files. For that, I am using a powershell script.

As you can see, in the database I have some special characters (Danish language).

But in the exported files, those characters are replaced with a ? as you can see below :

For information, in my powershell script, here is the line exporting the file :

$DataSet.Tables[0] | Export-Csv $extractFile -NoTypeInformation -Encoding "ISO-8859-15"

Can anyone help? Thanks!

EDIT :

@JamesQMurphy here is the code

Answer 1

Tested this and the correct encoding for me was BigEndianUnicode

Change your encoding to this:

$DataSet.Tables[0] | Export-Csv $extractFile -NoTypeInformation -Encoding BigEndianUnicode