Select Foreign Characters Issue

Databases
1

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?

Cheers!
Ryan

2

Ok, so I converted to utf8_bin to better point out the foreign characters.

But here’s my next issue. The convert did something strange to rows with foreign characters.

Such as, when I search for a row with ‘é’, I get this: 70656ec3a96c6f7065206372757a, which is the table’s version of “penélope cruz”

It’s odd.

Cheers
Ryan