UTF-8 & unicode everywhere
iconv -f ISO_8859-1 -t UTF-8 $i > tmpfile
CREATE DATABASE mydb
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;
https://en.wikibooks.org/wiki/Unicode/List_of_useful_symbols
␣ ☐ • ► - TODO
★ ☒ ✗ ✘ - KO
☆ ☑ ✓ ✔ - OK
UTF-8 & unicode everywhere
iconv -f ISO_8859-1 -t UTF-8 $i > tmpfile
CREATE DATABASE mydb
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;
https://en.wikibooks.org/wiki/Unicode/List_of_useful_symbols
␣ ☐ • ► - TODO
★ ☒ ✗ ✘ - KO
☆ ☑ ✓ ✔ - OK