Skip to content

Instantly share code, notes, and snippets.

@terrorobe
Created January 23, 2018 19:24
Show Gist options
  • Save terrorobe/801610db3fd92ac3830abebf7616317f to your computer and use it in GitHub Desktop.
Save terrorobe/801610db3fd92ac3830abebf7616317f to your computer and use it in GitHub Desktop.
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> SELECT '\U+1F4A3';
+------+
| ? |
+------+
| 💣 |
+------+
1 row in set (0.00 sec)
mysql> show warnings;
Empty set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment