id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
4093	Oracle BooleanFields display 1/0 instead of True/False	Ben Khoo	Jacob	"Hello,

Firstly congratulations on the Oracle support. I have been using it for the last few months and it is looking really good.

I have noticed a bug in the Oracle handling of BooleanFields. When querying a boolean attribute of an object, I am receiving 1 or 0 instead of True and False. An example is showed below.

{{{
In [1]: from django.contrib.auth.models import *

In [2]: u = User.objects.all()[0]

In [3]: u.is_superuser
Out[3]: 1

In [4]: u.is_staff
Out[4]: 0

In [5]: u.is_staff = True

In [6]: u.is_staff
Out[6]: True

In [7]: u.save()

In [8]: u.is_staff
Out[8]: True

In [9]: p = User.objects.get(pk=u.id)

In [10]: p.is_staff
Out[10]: 1

In [11]: p.is_superuser
Out[11]: 1

}}}

This is mentioned briefly in ticket [http://code.djangoproject.com/ticket/87 #87] however it has long since been closed.

Kind Regards
Ben
"		closed	Uncategorized	other branch		fixed	Oracle BooleanField		Unreviewed	0	0	0	0	0	0