MySQL diacritic insensitive search (spanish accents)

by

Character sets & collations, not my favorites, but they DO work:

mysql> SET NAMES latin1;
mysql> SELECT 'lápiz' LIKE 'lapiz';
+-----------------------+
| 'lápiz' LIKE 'lapiz' |
+-----------------------+
|                     0 | 
+-----------------------+
1 row in set (0.01 sec)

mysql> SET NAMES utf8;
mysql> SELECT 'lápiz' LIKE 'lapiz';
+-----------------------+
| 'lápiz' LIKE 'lapiz' |
+-----------------------+
|                     1 | 
+-----------------------+


mysql> SET NAMES latin1;
mysql> SELECT _utf8'lápiz' LIKE _utf8'lapiz' ;
+---------------------------------+
| _utf8'lápiz' LIKE _utf8'lapiz' |
+---------------------------------+
|                               1 | 
+---------------------------------+

A nice chapter to read in the manual:Character Set Support

More Related Contents:

  1. strange character encoding of stored data , old script is showing them fine new one doesn’t
  2. Convert latin1 characters on a UTF8 table into UTF8
  3. PDO + MySQL and broken UTF-8 encoding
  4. Can’t insert Chinese character into MySQL
  5. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  6. UTF-8 character encoding battles json_encode() [duplicate]
  7. Save Accents in MySQL Database
  8. UTF-8 not working in HTML forms
  9. the update query just update the last row and affect other with it’s value
  10. How to insert images into a database using PHP [closed]
  11. How to change mysql to mysqli?
  12. php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
  13. How do I use password hashing with PDO to make my code more secure? [closed]
  14. MySQLi prepared statements error reporting [duplicate]
  15. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  16. PHP Fatal error: Class ‘PDO’ not found
  17. Connect to a MySQL server over SSH in PHP
  18. How to store NULL values in datetime fields in MySQL?
  19. UTF-8 encoded html pages show � (questions marks) instead of characters
  20. PHP Warning: mysqli_connect(): (HY000/2002): Connection refused
  21. Javascript function post and call php script
  22. while ($row = mysql_fetch_array($result)) – how many loops are being performed?
  23. Trying to access array offset on value of type bool
  24. How to get a query error from prepare() in PDO PHP?
  25. Fatal error: Call to a member function query() on null
  26. How to insert json array into mysql database
  27. MySQL GROUP BY and Fill Empty Rows
  28. mysql injection damages?
  29. PHP PDO how to run a multiple query request?
  30. mysql_connect VS mysql_pconnect [closed]

Leave a Comment