Replace accented letters in mysql column not working

Question

Why won't the following query work on the accented characters in my column?

UPDATE people SET firstname = REPLACE(firstname,'à','a');

It works fine when I do:

UPDATE people SET firstname = REPLACE(firstname,'e','a');

The database character set is utf8mb4. I've tried changing the column's collation, but that didn't work.

Edit: I added this before my query and it worked:

mysqli_set_charset($conn,"utf8mb4");

Possible duplicate of [Accented characters in mySQL table](http://stackoverflow.com/questions/14083847/accented-characters-in-mysql-table) — Quinton, Apr 01 '17 at 22:30

score 1 · Accepted Answer · edited May 23 '17 at 12:17

1

I think that's what you are needing to do for your DB to accept accented characters.

edited May 23 '17 at 12:17

Community

answered Apr 01 '17 at 21:54

Quinton

Thanks. I updated my question with the line that worked for me. – user3080392 Apr 02 '17 at 00:41

1 Answers1