Hi

pá 20. 11. 2020 v 15:28 odesílatel Dirk Mika <dirk.m...@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.m...@mikatiming.de
> www.mikatiming.de
>
> AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
> Geschäftsführer: Harald Mika, Jörg Mika
>
>
>

Reply via email to