Changing to UFT-8 encoding can be a pain when you’re doing it from a GUI like MySQL Workbench.
There’s always an easier way to do it with some basic SQL.
The utf8 in mySQL doesn’t actually create a real UTF8 database. It creates a proprietary subset. Real UTF8 in MySQL is called utf8mb4.
-- convert the data that already exists to the character set utf-8
ALTER TABLE <table> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- change the character set to utf-8
ALTER TABLE <table> DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- change specific columns
ALTER TABLE <table> CHANGE <column_name> <column_name> VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Hell yes! I’m tired of working for other people. I want to work with my awesome students on social projects, business projects, making innovative machinery, robotics, custom software that’ll change the world. I don’t want to be stuck in a 9-5 job. I don’t want to work until I’m 60 years old.
I want to live my life doing something I love and having my own business that supports that.
So I’ve decided to create my own business, a company. It’s gonna be awesome!