models.TextField encodes data wrong on 4001+ characters on Oracle 10g
|Reported by:||walter.stafford@…||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||1.0|
|Severity:||Keywords:||TextField, Oracle 10g, NCLOB|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
When using a models.TextField with a length of greater than 4000 characters the input is encoded incorrectly using Oracle 10g (NCLOB).
Up to 4000 characters is fine, anything over causes an input with a length(col) 1/2 the original string length. I'm guessing that somewhere the encoding is getting mixed up.
It seems removing explicitly settings input_size = NCLOB can correct the issue but I don't know what impact this has.