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
27219	Emoji don't work in TextFields using Oracle backend	dmedvinsky	nobody	"When using cx_Oracle as a backend, I can't use Emoji in TextFields, which are stored as NCLOBs in the database. When inputting an emoji and saving them in the database, upon retrieving I get four replacement charaters (�) per emoji instead.

Django [https://github.com/django/django/blob/18c72d59e0807dae75ac2c34890d08c1e0972d0a/django/db/backends/oracle/base.py#L44 uses hardcoded NLS_LANG="".UTF8""] variable, which is outdated, only supports Unicode standard version 3 and cannot properly store 4-byte characters. [https://docs.oracle.com/database/121/NLSPG/ch6unicode.htm#NLSPG-GUID-EB57AB68-A390-4814-81DD-6B78D33310CC The Oracle documentation recommends] using the AL32UTF8 encoding instead, which supports latest Unicode standard and stores 4-byte characters properly.

The change that fixes the emoji for me: https://github.com/django/django/pull/7241

I recognize that it needs some tests, so I seek the help from those with better knowledge of Django test cases than me. If someone can kindly direct me, I can create the test for this case."	Bug	closed	Database layer (models, ORM)	1.10	Normal	fixed	oracle, unicode		Accepted	1	0	0	0	0	0