Alright, from PHP MY Admin I've attempted to convert a table and/or column in table to :
alter table `tags` convert to character set utf8 collate utf8_unicode_ci;
I am doing this because if I try to search for 'é', I get every row that has the letter "e" in it. I just want the ones with foreign characters.
I'm trying to replace every foreign character, which are mistakes, with English equivalents, so I am attempting to weed them all out. Right now the table is not allowing me to do this.
I run that query and then try again to search 'é' and get the same response.
Any feedback to get me to the solution I'm seeking?