From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Set COLLATE on a session level |
Date: | 2020-11-20 14:32:48 |
Message-ID: | CAFj8pRAk21ke-CQ5mDg8wAk2W=oc7fM6_9JvAvpbBOnJDz+kPQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
pá 20. 11. 2020 v 15:28 odesílatel Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)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(dot)mika(at)mikatiming(dot)de
> www.mikatiming.de
>
> AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
> Geschäftsführer: Harald Mika, Jörg Mika
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2020-11-20 14:47:17 | Re: Set COLLATE on a session level |
Previous Message | Dirk Mika | 2020-11-20 14:28:25 | Re: Set COLLATE on a session level |