jian he writes:
> select * from pktable where x = 'Å' collate ignore_accents;
> --return one row
> execute q6('Å' collate ignore_accents);
> --return zero rows
> not sure return zero rows is desired.
The parameter symbol just represents a value, which does not
carry any collation information.
jian he 于2024年10月24日周四 16:56写道：
> hi.
>
> $Subject setup
>
> CREATE COLLATION case_insensitive (provider = icu, locale =
> '@colStrength=secondary', deterministic = false);
> CREATE COLLATION ignore_accents (provider = icu, locale =
> '@colStrength=primary;colCaseLevel=yes', deterministic = false
