Re: Set COLLATE on a session level
| От | Pavel Stehule |
|---|---|
| Тема | Re: Set COLLATE on a session level |
| Дата | |
| Msg-id | CAFj8pRAk21ke-CQ5mDg8wAk2W=oc7fM6_9JvAvpbBOnJDz+kPQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Set COLLATE on a session level (Dirk Mika <Dirk.Mika@mikatiming.de>) |
| Ответы |
Re: Set COLLATE on a session level
|
| Список | pgsql-general |
Hi
pá 20. 11. 2020 v 15:28 odesílatel Dirk Mika <Dirk.Mika@mikatiming.de> napsal:
Thank you for the quick reply. But how is this usually solved?
Let's assume there is an app that accesses the same database from different countries. And in this app data should be displayed ordered. And the sort order is not identical in all countries.
Does the app have to send different SQL commands depending on the country? Not nice.
Do the data have to be sorted in the app? Not nice either.
the query is the same - you just use a different COLLATE clause. For Postgres there is not any other way.
Regards
Pavel
Regards
Dirk
--
Dirk Mika
Software Developer
mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany
fon +49 2202 2401-1197
dirk.mika@mikatiming.de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
В списке pgsql-general по дате отправления: