I want to compare two strings in a SQLite database without caring about accent and capitalization. I mean “Événement” should be equal to “evenèment”.
On Debian Wheezy, the SQLite package does
Tag: Collate
PostgreSQL – String Sorting Sequence (LC_COLLATE and LC_CTYPE)
Obviously, since version 8.4, PostgreSQL allows each database to use a different locale.
So I went to the document to read about the locale (http://www. postgresql .org/docs/8.4/static/locale.html)