Does mysql latin1 also support emoji character? -

now because below phenomenon feel totally not understand character set. @ first think utf8mb4 support emoji character e.g. 😀. see below:

as of mysql 5.5.3, utf8mb4 character set uses maximum of 4 bytes per character supports supplemental characters 

but accidentally found phenomenon,see below:

mysql> show variables 'character%'; +--------------------------+---------------------------------------+ | variable_name            | value                                 | +--------------------------+---------------------------------------+ | character_set_client     | latin1                                | | character_set_connection | latin1                                | | character_set_database   | latin1                                | | character_set_filesystem | binary                                | | character_set_results    | latin1                                | | character_set_server     | utf8mb4                               | | character_set_system     | utf8                                  | | character_sets_dir       | /opt/mysql/server-5.6/share/charsets/ | +--------------------------+---------------------------------------+ mysql> show create table t4\g *************************** 1. row ***************************    table: t4 create table: create table `t4` (   `data` varchar(100) default null ) engine=innodb default charset=latin1 mysql> insert t4 select '\u+1f600'; mysql> select * t4; +------+ | data | +------+ | 😀     | +------+ 

now i'm confused, seems latin1 support emoji character. know must illusion, don't know how clear it?

you cannot store other iso-8859-1 characters latin1 field without converting e.g. base64

it might work, fail later @ point. in special having multibyte characters emoticons.