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
30954	NVARCHAR2 fields are not using cx_Oracle.NCHAR.	Jaume Moral	nobody	"When inserting or updating NVHARCHAR2 fields and we need to store special char in a parameter ""x"" we need to use

cursor.setinputsizes(x=cx_Oracle.NCHAR)

I found this is this discussion 

https://github.com/oracle/python-cx_Oracle/issues/119

As far as I know, this is not implemented in Oracle backend. In OracleParam class, input_size is used with some data types (TIMESTAMP, CLOB...) but not for NCHAR. I tried to patch it forcing NCHAR in every string, but I'm sure this is not the best way to do it.

We can see this bug in an Oracle DB with ISO8859 charset, when using models with CharField (that maps to NVARCHAR2) and with any non-iso8859 character (for example, ""ć""). Without the patch,  this special chars turn into ""¿"" in database."	Bug	closed	Database layer (models, ORM)	dev	Normal	wontfix	oracle charset		Unreviewed	0	0	0	0	0	0