Daniel Verite schrieb am 04.10.2019 um 18:49:
Creating works, but apparently on Windows ICU does not support this.
After installing v12 on windows with the EDB installer, I notice
that it ships with ICU 53, a relatively old version (2014).
Concerning the problem just above (not the crash), ICU 53 is too old
to support BCP47 tags as collation attributes, as mentioned
at https://www.postgresql.org/docs/12/collation.html :
"The first example selects the ICU locale using a “language tag” per
BCP 47. The second example uses the traditional ICU-specific locale
syntax. The first style is preferred going forward, but it is not
supported by older ICU versions.
With ICU 53 or older, instead of the locale above, we must use the
old-style syntax:
locale = 'de-DE@colStrength=secondary'
If you use that in your example, the case insensitive lookups should
work.
That indeed works, thanks a lot.
