CODEWITHSUNDEEP
mysqlcollation
dmgig
dmgig

Reputation: 4568

MySQL searching non-english characters - o = ø, etc

I have my mySQL collation set to utf8_general_ci and despite the fact that my searches are diacritical-insensitive, ie LIKE 'test' returns 'tést', some searches which I would like to work fail, in particular LIKE 'host' will NOT return 'høst'.

Two questions: Is there a table that will show which characters are equivalent for a particular collation? Is there a way to set two characters as equivalents in mySQL as an override?

Thanks for the help.

Upvotes: 2

Views: 441

Answers (1)

Robert H
Robert H

Reputation: 11730

To answer for first question you can referance collation-charts.org. It's kind of a pain because you will need to search each collation by hand, but it'll show you how they stack.

The relevant section in the MySQL manual can also be found here.

As far as your second question, I'm not sure if you can do an explicit override for a particular character; however you can create your own custom character set if you wish.

You can read about creating custom collations from the MySQL manual.

Upvotes: 2

Related Questions