or in other words, when are two varchars equal in postgres? when their bytes are? or some algorithm is applied?
On this topic, when I write my strings to the DB and search from the DB, should I canonicalize them first as NKFC (or some other), or just let the DB figure it out? In my specific case I use perl DBI with place holders to submit my queries.