SET NAMES utf8mb4;<br><br>-- helper: safe code point to utf8mb4 string using JSON unescape<br>DELIMITER //<br><br>DROP FUNCTION IF EXISTS unichar//<br>CREATE FUNCTION unichar(cp INT)<br>RETURNS VARCHAR(4) CHARSET utf8mb4<br>DETERMINISTIC<br>BEGIN<br>  DECLARE v INT;<br>  DECLARE hs INT;<br>  DECLARE ls INT;<br>  IF cp < 0x10000 THEN<br>    RETURN JSON_UNQUOTE(CONCAT('"\\u', LPAD(HEX(cp), 4, '0'), '"'));<br>  END IF;<br>  SET v = cp - 0x10000;<br>  SET hs = 0xD800 + FLOOR(v / 0x400);<br>  SET ls = 0xDC00 + (v % 0x400);<br>  RETURN JSON_UNQUOTE(<br>           CONCAT('"\\u', LPAD(HEX(hs), 4, '0'),<br>                  '\\u', LPAD(HEX(ls), 4, '0'), '"'));<br>END//<br>DELIMITER ;<br><br>-- idempotent create for the flag function<br>DELIMITER //<br>DROP FUNCTION IF EXISTS flag_emoji//<br>CREATE FUNCTION flag_emoji(cc VARCHAR(2))<br>RETURNS VARCHAR(8) CHARSET utf8mb4<br>DETERMINISTIC<br>BEGIN<br>  DECLARE base INT DEFAULT 127462; -- U+1F1E6 REGIONAL INDICATOR SYMBOL LETTER A<br>  IF cc IS NULL OR cc NOT REGEXP '^[A-Za-z]{2}$' THEN<br>    RETURN NULL;<br>  END IF;<br><br>  RETURN CONCAT(<br>    unichar(base + ASCII(UPPER(SUBSTRING(cc, 1, 1))) - ASCII('A')),<br>    unichar(base + ASCII(UPPER(SUBSTRING(cc, 2, 1))) - ASCII('A'))<br>  );<br>END//<br>DELIMITER ;<br><br>-- examples<br>SELECT flag_emoji('GB') AS gb, flag_emoji('us') AS us, flag_emoji('de') AS de;<br>

mysql> SELECT flag_emoji('GB') AS gb, flag_emoji('us') AS us, flag_emoji('de') AS de;<br>+----------+----------+----------+<br>| gb       | us       | de       |<br>+----------+----------+----------+<br>| 🇬🇧         | 🇺🇸         | 🇩🇪         |<br>+----------+----------+----------+<br>1 row in set (0.00 sec)<br>

So, here's some zeitgeist to put together:

Unicode flags are just the combination of the regional indicator symbols compart.com/en/unicode/U+1F1E6, so 🇫+ 🇷 gives 🇫🇷

And framapiaf.org/@sylvestre/11513…

So maybe you could... `| cargo run tr A-Z 🇦-🇿 `

Sylvestre

2025-09-02 13:37:47

@zacchiro @CoolSWEng echo "💐💩🌷" | cut -d"💩" -f1

with the rust coreutils
💐
with GNU:
cut: the delimiter must be a single character

Getting there! I can now (inefficiently) see how many page views and (roughly) how many unique users have visited my blog.

I can also see where people are coming from on a specific day.

(Remember, this is just for me to noodle about with. This isn't going to be an amazingly accurate, professional-grade plugin.)

These are the countries which send the most visitors to my blog.

I'm using local GeoIP database - so I don't have to send anyone's IP address to a 3rd party. Also keeps costs at zero!