Django & Postgresql: Override locale for sorting?

Question

I have a simple Django app with a Postgresql database. The database is configured with nn_NO.UTF-8 locale.

mything=>\l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 mything   | postgres | UTF8     | nn_NO.UTF-8 | nn_NO.UTF-8 | =Tc/postgres         +
           |          |          |             |             | postgres=CTc/postgres+
           |          |          |             |             | me=CTc/postgres

Let's say there's a table MyTable. I want MyTable.objects.order_by('name') to sort according to en_US rules, not nn_NO. Is it possible to override the sorting locale from Python/Django, or do I have to recreate the entire database?

settings.py contains

LANGUAGE_CODE = 'en-us'
TIME_ZONE = 'UTC'
USE_I18N = True
USE_L10N = True
USE_TZ = True

Check this: stackoverflow.com/questions/18935712/…

anon
– anon

2016-08-25 09:00:38 +00:00
Commented Aug 25, 2016 at 9:00 — anon
– anon, Commented Aug 25, 2016 at 9:00

Åsmund · Accepted Answer · 2016-08-25 11:14:05Z

0

Radosław Ganczarek's comment points to the right answer:

from django.db.models import Func, F
name_en = Func(
    'name',
    function='en_US',
    template='(%(expressions)s) COLLATE "%(function)s"')
sorted_things = MyTable.objects.order_by(name_en)

https://docs.djangoproject.com/en/1.9/ref/models/expressions/#func-expressions

answered Aug 25, 2016 at 11:14

Åsmund

1,4491 gold badge19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django & Postgresql: Override locale for sorting?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related