Debian sid
PG v.9.1.2-1
============
Hi list,
I'd like to be able to perform queries on a table regardless of:
* upper/lower case (found it: index on lower(column) + qry on
lower(search)),
* any accentuated letter, ie:
looking for 'chale'
should return: 'Châle', 'shalé', 'Chàlè', 'čhale', etc.
1- I guess my question has a link to COLLATE, but in which way?
(does such a collation exists?)
2- Where is it better to apply it, directly to column or just to
index?
JY
--
Shit Happens.