bradzacher/mysqldump

Special characters on JSON field types are not exported correctly

abelrgr opened this issue · 3 comments

abelrgr commented

On the dump for the JSON field Types, the special characters does not export well :(

Original

["AF", "Afġānistān"]

Exported:

["AF", "Afġ�nist�n"]

Pd. Sorry for my bad english

cioddi commented

Have you tried a different charset.
default is UTF8_GENERAL_CI which does not contain those special characters, maybe it works if you set charset: 'UTF8_UNICODE_CI',

If that does not help there is probably more information required to answer this question.

Kosta-Github commented

I am using charset: 'utf8mb4' in the mysql connection parameters which also solved issues with emojis... :-)

  • 👍1
xiongsongsong commented

image

I try set utf8mb4 or utf8mb4_unicode_ci, but still fail.
column elements is json field.

if I use original mysqldump, it's no problem.