How to conduct an Accent Sensitive search in MySql

by

If your searches on that field are always going to be accent-sensitive, then declare the collation of the field as utf8_bin (that’ll compare for equality the utf8-encoded bytes) or use a language specific collation that distinguish between the accented and un-accented characters. 

col_name varchar(10) collate utf8_bin

If searches are normally accent-insensitive, but you want to make an exception for this search, try;

WHERE col_name="abád" collate utf8_bin

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 display UTF-8 characters in phpMyAdmin?
  7. UTF-8: General? Bin? Unicode?
  8. How to remove accents in MySQL?
  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. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  18. Detecting utf8 broken characters in MySQL
  19. MySQL throws Incorrect string value error
  20. Mysql server does not support 4-byte encoded utf8 characters
  21. UTF8 problem with MySQL 5
  22. MySQL – Trigger for updating same table after insert
  23. MySQL Foreign Key Error 1005 errno 150 primary key as foreign key
  24. How to store a datetime in MySQL with timezone info
  25. mysql after insert trigger which updates another table’s column
  26. Error Code: 1406. Data too long for column – MySQL
  27. Search for string within text column in MySQL
  28. Clear MySQL query cache without restarting server
  29. Does mysql have the equivalent of Oracle’s “analytic functions”?
  30. Mysql insert into 2 tables

Leave a Comment