ee "Best practice" in http://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored It sounds like you don't have the connection parameter (or SET NAMES
).
What you tried should have worked:
INSERT INTO unicode_test (value) VALUES ('𤭢');