MySQL :: Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

New Topic

Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

Posted by: Bjørn Munch
Date: March 19, 2024 06:21AM

National flags are not represented as single characters in Unicode. Instead the emjois are encoded as two characters from the set of "Regional indicator symbols". In your example it will be the ones corresponding to the letters U and S. Notepad presumably does not support these and does not know how to render them. I see the same if I paste your flag into my Emacs: it shows the hex codes.

More details here https://en.wikipedia.org/wiki/Regional_indicator_symbol

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Question marks instead of emoji when exporting from the mysql database to a .sql file

418

Микола Расік

March 18, 2024 04:18AM

Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

201

Bjørn Munch

March 19, 2024 06:21AM

Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

198

Микола Расік

March 21, 2024 12:04PM

Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

171

Bjørn Munch

March 22, 2024 08:24AM

Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

188

Микола Расік

March 22, 2024 05:03PM

Re: Question marks instead of emoji when exporting from the mysql database to a .sql file

274

Bjørn Munch

March 27, 2024 02:31AM

Sorry, only registered users may post in this forum.

Click here to login

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.