Rails 4 and PostgreSQL - Query to match a String using LIKE with an Accented String stored in the Database

Asked Feb 28 '16 at 00:54

Active Feb 28 '16 at 00:54

Viewed 45 times

My application have members with fields with accented (spanish) characters. Example:

m.lastname = "Fernández"

I want to find this member using the PostgreSQL LIKE operator like this:

SELECT * FROM members WHERE lastname LIKE '%rna%';

But, because 'a' and 'á' are different characters, that doesn't work. Any help on this?

asked Feb 28 '16 at 00:54

dmferrari

http://stackoverflow.com/questions/11005036/does-postgresql-support-accent-insensitive-collations – potashin Feb 28 '16 at 01:51
Thats what I need! Thank you @potashin – dmferrari Feb 28 '16 at 03:43
As potashin pointed out, the solution is here: https://stackoverflow.com/questions/11005036/does-postgresql-support-accent-insensitive-collations – dmferrari Feb 28 '16 at 03:46

0 Answers0