Oracle unicode sorting

1 view
Skip to first unread message

SlafS

unread,
Jun 4, 2009, 6:15:44 AM6/4/09
to Django users
Hi there!

I've got a Django app working on the Oracle backend. I have a table/
model with a char field and I store there strings (names) that contain
polish letters. On the admin panel when I sort those names, ones that
are starting with polish letters are after those that are starting
with letter 'z'. Weird thing is that $ORACLE_HOME/sqlplus is sorting
correctly the query and moreover even cx_Oracle sample
'ReturnUnicode.py' is printing the results correctly.

my model looks like this (sorry for polish naming) :
#encoding: utf-8

class Projekt(models.Model):
id = models.AutoField(db_column='id', primary_key=True)
nazwa = models.CharField(db_column='nazwa', unique=True,
max_length = 100)
...
class Meta:
db_table = 'Projekty'
verbose_name = _(u'Projekt')
verbose_name_plural = _(u'Projekty')
ordering = ['nazwa']
def __unicode__(self):
return u"%s" % (self.nazwa[:35],)

Can anyone tell me what could be the issue ?

Regards
Reply all
Reply to author
Forward
0 new messages