mysql replace accented characters
Posted
by pixeline
on Stack Overflow
See other posts from Stack Overflow
or by pixeline
Published on 2010-05-02T12:18:59Z
Indexed on
2010/05/02
12:27 UTC
Read the original article
Hit count: 649
Hi,
i would like to generate strict alphanumeric character logins from users' first and lastname. Since many of them are foreigners, their names have special characters (é, è, ï, ...). I would like to remove the accents (e,e,i,...) in the logins.
Here is my query. Is there a character set that does not contain accents?
UPDATE contacts SET login=CONVERT(LOWER(CONCAT(firstname,'.',lastname)) USING utf8);
© Stack Overflow or respective owner