#11487: Oracle encoding bug when saving more than 4000 characters
-------------------------------------+-------------------------------------
               Reporter:  mdpetry    |        Owner:  nobody
                 Status:  reopened   |    Milestone:  1.1
              Component:  Database   |      Version:  SVN
  layer (models, ORM)                |     Keywords:  oracle database nclob
             Resolution:             |  clob
           Triage Stage:  Accepted   |    Has patch:  1
    Needs documentation:  0          |  Needs tests:  0
Patch needs improvement:  0          |
-------------------------------------+-------------------------------------
Changes (by Goldan):

 * status:  closed => reopened
 * keywords:  oracle database => oracle database nclob clob
 * resolution:  fixed =>
 * cc: Goldan (added)


Comment:

 This issue seems to be a bit more complicated.


 {{{
 self.input_size = Database.CLOB
 }}}


 causes the following error when inserting more than 4000 characters.


 {{{
 DatabaseError: ORA-12704: character set mismatch
 }}}


 Changing it to


 {{{
 self.input_size = Database.LONG_STRING
 }}}


 (as initially suggested by the reporter) works ok.

 I've attached the patch and a test case that fails with CLOB.

 I'm using cx_Oracle version 5.0.4 with unicode support and Oracle9i
 Enterprise Edition Release 9.2.0.1.0 - Production.

-- 
Ticket URL: <http://code.djangoproject.com/ticket/11487#comment:23>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Reply via email to