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?
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"
This topic is now closed. New replies are no longer allowed.