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
* 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
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2011-12-29 20:59:26|
|Subject: Re: column or index collation [SOLVED]|
|Previous:||From: Jean-Yves F. Barbier||Date: 2011-12-29 16:37:09|
|Subject: Re: > and >= give the same result|