Re: sort order for UTF-8 char column with Japanese UTF-8
От | Matthias Apitz |
---|---|
Тема | Re: sort order for UTF-8 char column with Japanese UTF-8 |
Дата | |
Msg-id | Yfwo54pi7mMGNVdI@pureos обсуждение исходный текст |
Ответ на | Re: sort order for UTF-8 char column with Japanese UTF-8 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: sort order for UTF-8 char column with Japanese UTF-8
|
Список | pgsql-general |
El día jueves, febrero 03, 2022 a las 10:00:37 -0500, Tom Lane escribió: > Matthias Apitz <guru@unixarea.de> writes: > > El día jueves, febrero 03, 2022 a las 11:14:55 +0100, Matthias Apitz escribió: > >> With ESQL/C on a PostgreSQL 13.1 server I see the result of this query: > >> select katkey,normform from swd_anzeige where normform >= 'A' ORDER BY ASC; > >> coming out in this order: > >> ... > >> I loaded the same table in my server, but can't get the same order with > >> psql: > > Do the two machines produce the same results if you sort the data in > question with sort(1)? (Being careful to set LANG=de_DE.UTF-8 of > course.) I rather doubt this has anything to do with Postgres as such; > there are lots of inter-system and inter-release discrepancies in > collation behavior. I've created a small text file 'swd' with some of the UTF-8 lines in question. On my Linux mobile phone (a Debian Linux) it gives: purism@pureos:~$ LANG=de_DE.UTF-8 sort swd A A010STRUKTUR A010STRUKTUR A010STRUKTUR A0150SUPRALEITER ゲアハルト・A・リッター ゲルハルト・A・リッター チャールズ・A・ビアード On my FreeBSD laptop the same file sorts as guru@c720-r368166:~ $ LANG=de_DE.UTF-8 sort swd A ゲアハルト・A・リッター ゲルハルト・A・リッター チャールズ・A・ビアード A010STRUKTUR A010STRUKTUR A010STRUKTUR A0150SUPRALEITER I'll check tomorrow with the admins of the remote server (a SuSE Linux). Thanks for the hint. matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub
Вложения
В списке pgsql-general по дате отправления: