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?

Bogdan Iulian Bursuc
  • 2,215
  • 1
  • 16
  • 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
  • 35,221
  • 12
  • 85
  • 90