Re: Oracle NLS sorting

2011-12-19 Thread slafs
Hi Just to clarify things up. Setting an environment variable NLS_SORT="POLISH" ensures the correct sorting in Oracle. This is in case anyone hit this topic. Regards Sławek -- You received this message because you are subscribed to the Google Groups "Django developers" group. To view this

Re: Oracle NLS sorting

2009-06-05 Thread slafs
Hi On 5 Cze, 22:39, Ian Kelly wrote: > We could add keys to the DATABASE_OPTIONS setting that would cause > this to be set.  I would be concerned about allowing NLS_TERRITORY to > be changed in this manner unless we also implement a different > solution for the weekday inconsistency. The NLS_TE

Re: Oracle NLS sorting

2009-06-05 Thread Ian Kelly
On Fri, Jun 5, 2009 at 2:05 PM, Antoni Aloy wrote: > I think in your case is quite the same, take a look at > http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm > and the set the enviornment variable NLS_LANG on your application. In > the setting perhaps. This won't wor

Re: Oracle NLS sorting

2009-06-05 Thread Ian Kelly
On Fri, Jun 5, 2009 at 1:29 PM, slafs wrote: > another thing is that I don't understand why NLS_TERRITORY has to be > set to 'AMERICA'. Because the region determines how the days of the week are numbered. I have no idea what mapping POLAND uses, but if it's different from AMERICA, then expect to

Re: Oracle NLS sorting

2009-06-05 Thread Antoni Aloy
2009/6/5 slafs : > > Hi there! > > It's my first message here so forgive any mistakes. I don't know even > if I should write about this here. > Anyway... > I was having a problem with proper (polish) ordering of my queries > within a queryset from an Oracle backend. > Recently we had some weird pr

Oracle NLS sorting

2009-06-05 Thread slafs
Hi there! It's my first message here so forgive any mistakes. I don't know even if I should write about this here. Anyway... I was having a problem with proper (polish) ordering of my queries within a queryset from an Oracle backend. (check http://groups.google.com/group/django-users/browse_thre