On 2022-12-10 "Peter J. Holzer" <hjp-pgsql(at)hjp(dot)at> wrote:
> > * your logic only works by accident for some languages (try to
> > upcase a `ß` or a `ı`)
>
> This is also true of upper() and lower() and SQL does provide those.
Well…
> select upper('ı');
┌───────┐
│ upper │
├───────┤
│ I │
└───────┘
(1 row)
> select upper('ß');
┌───────┐
│ upper │
├───────┤
│ ß │
└───────┘
(1 row)
> select upper('ä');
┌───────┐
│ upper │
├───────┤
│ Ä │
└───────┘
(1 row)
Of course all of this is dependent of locale, too.
--
Dakkar - <Mobilis in mobile>
GPG public key fingerprint = A071 E618 DD2C 5901 9574
6FE2 40EA 9883 7519 3F88
key id = 0x75193F88