Re: Norwegian Sorting

I don't know if this is the exact problem, but I've addressed this
previously here:

http://www.pineappledonut.org/2010/12/05/data-collations/

I've only worked with MySQL before, so I'm not sure about how
collations work in POSTGres, but it may provide some pointers.

cheers
L.

On Sat, Sep 10, 2011 at 15:49, Иван Иванов <wankata@openintegra.com> wrote:
> На Fri, 09 Sep 2011 22:18:50 +0100
> Tim Sawyer <list.django@calidris.co.uk> написа:
>
>> Hi Folks,
>>
>> I have a django site which is against a postgres database which is
>> UTF8. I have a large droplist with international names in, and it
>> doesn't appear to be sorting correctly.
>>
>> The list contains Ingvar Mæland and Børre Børresen.  I'm told that
>> the Norwegian sort order should be X Y Z Æ Ø Å.  That's not what I'm
>> seeing
>> - I think it's just sorting them as A's.
>>
>> I found Ingvar Mæland in the place I would expect to find Maland
>>
>> I found Børre Børresen in the place I would expect to find Barresen
>>
>> LANGUAGE_CODE = 'en-gb', in settings.py.
>>
>> Does anyone know what I've missed?
>
> You probably have problem in the postgres itself. I had simmilar
> problems with mysql, where it returns "a" and "a" with some diacritical
> mark when I do select with where clause which searches for one of them.
>
> So better try to make the same query directly in some postgres client
> to see if the result is broken.
>
> And here two mails, which discuss your problem from other mailing lists:
> http://archives.postgresql.org/pgsql-novice/2007-09/msg00066.php
> http://freebsd.1045724.n5.nabble.com/Enabling-norwegian-sorting-rules-in-PostgreSQL-td4256621.html
>
>> Thanks,
>>
>> Tim.
>>
>
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To post to this group, send email to django-users@googlegroups.com.
> To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
>
>

--
The politician's syllogism, also known as the politician's logic or
the politician's fallacy, is a logical fallacy of the form:
- We must do something
- This is something
- Therefore, we must do this.
(via http://bestofwikipedia.tumblr.com/ )

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.