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 > > >