I'm trying to store strings that may include special characters. Presuming the gurus under the hood here have it working, I'd like to be able to store and retrieve characters similar to the following:
© ɤ ë ¾ ñ
My meta tag:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
...doesn't specify which UTF-8 collation to use, so I left it as default "utf8_general_ci"....but I'm getting random odd characters.
I figure it's got to be one of the 3 below -- and I've tried them all on the table, but wondered if maybe that corrupted the data by switching it with data already inside. (No worries, its just filler data for dev purposes.)
Which collation should I use to not have problems with those types of characters?
Thanks for your wisdom!