How to remove accents in MySQL?

by

If you set an appropriate collation for the column then the value within the field will compare equal to its unaccented equivalent naturally.

mysql> SET NAMES 'utf8' COLLATE 'utf8_unicode_ci';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT 'é' = 'e';
+------------+
| 'é' = 'e' |
+------------+
|          1 |
+------------+
1 row in set (0.05 sec)

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  3. How to make MySQL handle UTF-8 properly
  4. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  5. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  6. How to conduct an Accent Sensitive search in MySql
  7. How to display UTF-8 characters in phpMyAdmin?
  8. UTF-8: General? Bin? Unicode?
  9. Differences between utf8 and latin1
  10. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  11. MySQL VARCHAR Lengths and UTF-8
  12. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  13. Fetching UTF-8 text from MySQL in R returns “????”
  14. How to fix double-encoded UTF8 characters (in an utf-8 table)
  15. Loading utf-8 encoded text into MySQL table
  16. MySQL command line formatting with UTF8
  17. Accent insensitive search query in MySQL
  18. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  19. Detecting utf8 broken characters in MySQL
  20. MySQL throws Incorrect string value error
  21. Mysql server does not support 4-byte encoded utf8 characters
  22. UTF8 problem with MySQL 5
  23. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  24. How to group by two rows in a column
  25. How to get UTF-8 working in Java webapps?
  26. How to perform grouped ranking in MySQL
  27. How to abort INSERT operation in MySql trigger?
  28. Mysql or/and precedence?
  29. The total number of locks exceeds the lock table size
  30. MySQL errorno 121

Leave a Comment