Query for words with special characters and normal input in mysql

Asked Oct 24 '16 at 19:29

Active Oct 24 '16 at 20:04

Viewed 49 times

I have a database with special characters like ā or ă so when the input is something like amor I want to query also the word āmor or ămor. I used the Sounds Like function but it does not work properly.

Here is my question: How do I do that?

edited Oct 24 '16 at 19:52

Drew

24,851
10
43
78

asked Oct 24 '16 at 19:29

1

That's too bad. Did you have a question? This site is for questions, not a place to list problems. – Marc B Oct 24 '16 at 19:36
@MarcB how is my edit? Did I polish the T well enough :p – Drew Oct 24 '16 at 19:53
if you use unicode charsets, then that kind of comparison is automatic. `select 'āmor' = 'amor'` -> `1`. – Marc B Oct 24 '16 at 19:54

Query for words with special characters and normal input in mysql

0 Answers0