Menu

#4936 (ok 4.4.9) utf8mb4 fields show only ????s for 4-byte Unicode characters after import

4.4.8
fixed
Normal
2015-06-04
2015-06-01
No

The export dialog is missing the option to export for utf8mb4. While the utf8 option creates a valid utf8 file, this
/*!40101 SET NAMES utf8 */;
should read
/*!40101 SET NAMES utf8mb4 */;
for utf8mb4 exports. A manual change shows that it works.

Steps to reproduce:
1. Create new database with utf8mb4_general_ci collation.
2. Create new table with a varchar column
3. Insert a smiley like this '😁'
4. Export the database or table
5. Import the database or table
6. Look at the smiley. You'll see four question marks.
7. Now change utf8 to utf8mb4 in the SQL file
8. Import again
9. Look at the smiley. It was correctly imported.

Discussion

  • Madhura Jayaratne

    • assigned_to: Madhura Jayaratne
     
  • Madhura Jayaratne

    • summary: utf8mb4 fields show only ????s for 4-byte Unicode characters after import --> (ok 4.4.9) utf8mb4 fields show only ????s for 4-byte Unicode characters after import
    • status: open --> resolved
     
  • Marc Delisle

    Marc Delisle - 2015-06-04
    • Status: resolved --> fixed
     
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.