1

In my mysql database I have a city name in utf-8: "Bucureşti"

And if I do 

SELECT * 
FROM cities 
WHERE name LIKE 'Bucuresti';  <- without diacritic 'ş' it works in MySQL.

How can I achieve this in postgresql also?

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
Bogdan Iulian Bursuc
  • 2,115
  • 14
  • 19
  • 4
    http://stackoverflow.com/questions/11005036/does-postgresql-support-accent-insensitive-collations – Ashalynd Oct 20 '13 at 08:46

1 Answers1

1

Checkout out the unaccent extension, which is part of the contrib package.

Peter Eisentraut
  • 33,335
  • 12
  • 80
  • 87