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
13436	oracle startswith etc fails	kthhrv	nobody	"{{{

OracleDBModel.objects.filter(name__startswith='abc')

DatabaseError: ORA-01425: escape character must be character string of length 1
}}}
changing
django/db/backends/oracle/base.py

{{{
-'startswith': ""LIKE TRANSLATE(%s USING NCHAR_CS) ESCAPE TRANSLATE('\\' USING NCHAR_CS)"",
+'startswith': ""LIKE %s ESCAPE '\\'"",

}}}
appears to fix the problem"		closed	Database layer (models, ORM)	1.2		wontfix	oracle		Unreviewed	0	0	0	0	0	0