Would this also select characters with diacritical marks? For example,
eid | ename-----+-------1 | aaa2 | AAA3 | áäâ4 | āåȧ
— Andy
For that you need https://www.postgresql.org/docs/10/unaccent.html
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@xxxxxxxxxxxx
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
>> for further information.
