Reputation: 1122
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
.
Upvotes: 0
Views: 134
Reputation: 7124
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;
Upvotes: 1