Question marks instead of emoji when exporting from the mysql database to a .sql file
Posted by: Микола Расік
Date: March 18, 2024 04:18AM

I would like to export my emoji database, but I'm having a problem with the export. When I export my table to .sql some characters are replaced with "?". more precisely, the symbols of the flags. For example, such data (USA 🇺🇸 ☺) became such data after export (USA ?? ☺). I use mysql workbench. utf8mb4 is everywhere in the database. After exporting, I viewed the file through Notepad, there were signs "?" imported the same file into another database, the same "?" signs. Tell me, maybe someone knows how to be in such a situation)

I tried to put different encodings in the database, nothing works. looked through a bunch of different articles on this problem, could not solve anything, the problem remained

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.