How to set the correct encoding for uploaded CSV files?

Question

PostgreSQL

Hello, We have
added the function of exporting data to CSV., but the output is not the correct encoding. We use Symfony, Postgres. We look at the file on MacOS, Windows.
Tell me, what export settings need to be done in order for the data to be uploaded to CSV with normal encoding under MacOS / Windows?

Answer 1

Wrong encoding - what is it? Not the one that is used in the database or not the one you need?
In general, when generating a CSV (for example, using COPY), the encoding can be explicitly specified in the corresponding parameter .