I am using MySQL 8 and the dataset contains these 3 latin accent characters í ñ é. So the thing I am trying to figure out is why am I able to search í é, but not ñ when using the non-accented version of the character. What do I need to do so I can search all those characters by using the non-accent version?
My Collation on the DB/Table/Column is utf8mb4_spanish_ci and Character Set is utf8mb4.
CodePudding user response：
Well, the reason might be because ñ is not exactly n.
"The character “ñ” is a precomposed character because it is treated as an individual Unicode character and has a Unicode code point of U 00F1. Technically, this character can be decomposed into an equivalent string of a base character “n” (U 006E) and a combining tilde “~” (U 0303)." Reference
There is a way to make ñ recognizable as n by adding COLLATE in the query, such as:
SELECT * FROM baptism WHERE place LIKE '%n%' COLLATE utf8mb4_general_ci;