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
32767	inspectdb and sql non-boolean issues	kinglion	nobody	"**enviornment:**
python: 3.8
django: 3.2.3
pyodbc: 4.0.03
django-mssql-backend: 2.8.1


I'm sure the database config is correct.
1. when I run: python manage.py inspectdb, it come out issues like this:
{{{
# Unable to inspect table 'AllowList'
# The error was: __new__() missing 1 required positional argument: 'collation'
}}}

ps: when I change django version to 3.1x or 2.x, inspectdb can produce model.


2. when I use 
{{{
filetypes = Uploadfiletypes.objects.filter(status=True).order_by('filetype')
}}}

it produce this issue:

{{{
('42000', ""[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near 'ORDER'. (4145) (SQLExecDirectW)"")
}}}

I'm sure status is a boolean field, and True is a boolean type value. when I change the django version to 2.x, it don't have this issue.
"	Bug	closed	Database layer (models, ORM)	3.2	Release blocker	invalid	inspectdb, mssql, non-boolean		Unreviewed	0	0	0	0	0	0