Re: special characters are not being exported in the data dump file

[Barry Galbraith]

Sounds like you have a mixture of charactersets happening, input and output.
For an understanding of what is wrong, and more importantly, how to fix it, I recommend reading the excellent work of Rick James.
There's a lot to read, but it is worth it when you end up sorting your problem.

https://mysql.rjweb.org/doc.php/charcoll

Basically you need to ensure that when you are sending data to be stored, that the link to the database has the correct charset, and the table where you are storing it has the correct charset.
Then when retrieving the data, you have the correct charset on the link, and the presentation of that data has the correct charset.

Good luck,
Barry.