Japanese characters are garbled when exported in SQL format.

Describe the bug

When table data containing Japanese characters is exported in SQL format, some characters are not output correctly. For example, the word "テスト" in one column becomes "テス�".

When exporting to a file format other than SQL, the correct characters will be used. So I am wondering if there is something wrong with the SQL format export.

The collation of the table is "utf8_general_ci".

To Reproduce

Steps to reproduce the behavior:

1. Log in to phpMyAdmin.
2. Select a database and table.
3. Click on the Export tab.
4. Select SQL as the format and perform the export.
5. Open the exported file in a text editor.
6. Some Japanese characters are garbled.

Expected behavior

Japanese characters can be output to a file without being garbled when SQL format export is executed.

Server configuration

[Application Server]

• Operating system: Miracle Linux 8.3
• Web server:Nginx 1.20.0
• PHP version: 8.0.12
• phpMyAdmin version: 5.2.0
• Default Charset: UTF-8

[Database Server]

• Operating system: Windows Server 2008 R2 Standard
• Database version: MySQL 5.5.10
• Default Charset: Shift-JIS Japanese

Client configuration

• Browser: GoogleChrome 102.0.5005.115
• Operating system: Windows10