How to do mysqldump with session parameter SET SESSION collation_connection := 'utf8_unicode_ci';?

Question

MySQL

What key to specify or how else to dump the database with COLLATION_NAME different from the system ones? I need to dump the database with a specific COLLATION_NAME, not the system default.
Now I have:

mysqldump: Error: 'Illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE) for operation '='' when trying to dump tablespaces

Answer 1

mysqldump doesn't do any sorting, so specifying collation doesn't make sense for it. The dump will still contain those parameters of the database, tables and columns with which they were created.