| From: | Tim Clarke <tim(dot)clarke(at)minerva(dot)info> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Case Insensitive |
| Date: | 2019-03-28 12:09:25 |
| Message-ID: | 74504e0f-b223-891a-93fd-ec4eb155bdad@minerva.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On 28/03/2019 11:10, Andy Anderson wrote:
Would this also select characters with diacritical marks? For example,
eid | ename
-----+-------
1 | aaa
2 | AAA
3 | áäâ
4 | āåȧ
— Andy
For that you need https://www.postgresql.org/docs/10/unaccent.html
Tim Clarke
Main: +44 (0)1376 503500 | Fax: +44 (0)1376 503550
Web: https://www.manifest.co.uk/
Minerva Analytics Ltd
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | England
----------------------------------------------------------------------------------------------------------------------------
Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin(at)minerva(dot)info<mailto:admin(at)minerva(dot)info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics
Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here >><https://www.manifest.co.uk/legal/> for further information.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2019-03-28 12:38:50 | Re: Case Insensitive |
| Previous Message | Andreas Kretschmer | 2019-03-28 11:28:53 | Re: Case Insensitive |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brad Nicholson | 2019-03-28 12:38:50 | Re: Case Insensitive |
| Previous Message | Andreas Kretschmer | 2019-03-28 11:28:53 | Re: Case Insensitive |