FAQ Database Discussion Community


How to remove diacritics (accents) from a string?

string,dart,diacritics,unaccent
I'm trying to convert some strings that are in Czech, Spanish, French etc. I'd like to take out the accent marks in the letters while keeping the letter. (E.g. convert é to e, č to c, Ž to Z, ñ to n) What is the best way to achieve this?...

unaccent() preventing index usage in Postgres

sql,postgresql,indexing,openstreetmap,unaccent
I want to retrieve a way with a given name from an OpenStreetMap database imported into PostgreSQL 9.3.5, the OS is Win7 64-bit. In order to be a bit failure tolerant, I use the unaccent extension of Postgres. My query looks as follows: SELECT * FROM germany.ways WHERE lower(tags->'name') like...