Code:
$ echo $LANG
$ echo $LC_ALL
$ echo $LC_CTYPE
de_DE.UTF-8
$ echo $LC_COLLATE
( echo A ; echo b ; echo C ) | LC_COLLATE=de_DE.UTF-8 sort
A
b
C
$ ( echo A ; echo b ; echo C ) | sort
A
C
b
This is not very funny, and is one of the reasons why I do not use these normally.
But, the problem goes deeper. This is postgres, and here LC_COLLATE cannot be changed (because it builds all the indexes on it):
Code:
flowm=> select 'b' < 'A';
?column?
----------
f
(1 row)
flowm=> select 'b' < 'C';
?column?
----------
t
(1 row)
flowm=> show LC_COLLATE;
lc_collate
-------------
de_DE.UTF-8
(1 row)
Why is my PostgreSQL ORDER BY case-insensitive?
I have Postgres 9.4.4 running on Debian and I get the following ORDER BY behavior: veure_test=# show LC_COLLATE; lc_collate ------------- en_US.UTF-8 (1 row) veure_test=# SELECT
dba.stackexchange.com
Problems with sort order (UTF8 locales don't work) · Issue #216 · PostgresApp/PostgresApp
Hello, The pg_config points to a local directory that does not exists LOCALEDIR = /Applications/Postgres.app/Contents/Versions/9.3/share/locale Can you include it on further versions? ((enjoy)) cr
github.com