PowerShell 7.3 - Difficulty with Encoding Issues When Writing UTF-8 Files
I'm performance testing and I'm confused about I'm currently facing an issue where I need to export some data to a UTF-8 encoded CSV file using PowerShell 7.3, but it seems like the file is not being created with the correct encoding. I have a collection of objects that I generate and then attempt to export them using `Export-Csv`. However, when I open the resulting file in a text editor, it shows strange characters instead of the expected text. Here's what I've tried so far: ```powershell # Sample data to export $data = @( [PSCustomObject]@{ Name = 'Test'; Value = 'Hello, world!' }, [PSCustomObject]@{ Name = 'Example'; Value = 'This is a test.' } ) # Attempt to export to CSV $data | Export-Csv -Path 'output.csv' -NoTypeInformation ``` I've read that `Export-Csv` defaults to using `ASCII` encoding if no encoding is specified. So, I tried adding the `-Encoding` parameter explicitly: ```powershell $data | Export-Csv -Path 'output.csv' -NoTypeInformation -Encoding UTF8 ``` However, even with that change, the file still doesn't appear to be encoded in UTF-8. When I check the file in `Notepad++`, it shows as `ANSI` encoding. I've also tried using `Out-File` as a workaround: ```powershell $data | ConvertTo-Csv -NoTypeInformation | Out-File -FilePath 'output.csv' -Encoding UTF8 ``` But this also resulted in the same encoding issue. I even tried running PowerShell as an administrator thinking it might be a permission issue, but that didn't help either. What am I missing here? Is there a specific setting or method in PowerShell 7.3 that I should be using to ensure the CSV file is written in proper UTF-8 encoding? I need to ensure that special characters are preserved, and the current outcome is not sufficient. Any guidance would be greatly appreciated! The stack includes Powershell and several other technologies. I'm coming from a different tech stack and learning Powershell.