| From: | Marcel van Pinxteren <marcel(dot)van(dot)pinxteren(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Case insensitive collation |
| Date: | 2013-01-16 18:49:59 |
| Message-ID: | CAE3e+fOw5FrQ7ztUYeB4OSbnbE-Hup_cwYDTNvzYQ9Y0DuH8ww@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The subject has been discussed on this mailing list before, recently.
To be able to switch from SQL Server to Postgresql, for me this is
essential.
Therefore the question: are there plans to create a set of case
insensitive, and maybe also accent insensitive collations in the near
future?
I have no idea how complex this is, but it seems to me, looking at MySQL
and SQL Server that it's not such a strange thing to expect from a database
server.
I know I can use "lower" (even on indexes) and citext, but this feels like
patchwork, and would mean a lot of work when converting our database (with
122 tables).
Regards,
Marcel van Pinxteren
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-01-16 19:14:50 | Re: Case insensitive collation |
| Previous Message | Adrian Klaver | 2013-01-16 16:45:16 | Re: plpython intermittent ImportErrors RESOLVED |