> Yeah. My recommendation is just LOCALE: > > regression=# CREATE DATABASE test1 TEMPLATE=template0 ENCODING = > 'UTF8' LOCALE = 'C'; CREATE DATABASE regression=# CREATE DATABASE test2 > TEMPLATE=template0 ENCODING = 'UTF8' ICU_LOCALE = 'C'; > NOTICE: using standard form "en-US-u-va-posix" for locale "C" > CREATE DATABASE > > I think it's probably intentional that ICU_LOCALE is stricter about being given > a real ICU locale name, but I didn't write any of that code. > > regards, tom lane
CREATE DATABASE test1 TEMPLATE=template0 ENCODING = 'UTF8' LOCALE = 'C'; Doesn't seem to work at least not under mingw64 anyway. SELECT '+' < '-' ; Returns false
