Hi Everyone, I have run into a curious problem while using TextFields (NCLOB datatype) in the oracle branch.
The problem that I am having is that if I attempt to store a piece of text greater than 4000 characters in length. The save function will complete successfully however when I attempt extract the data from the database, all I receive is a series of '?' characters. For example >>> for i in range(3998,4003,1): ... s = 'a'*i ... t = Test(long_text=s) ... t.save() ... print 'text length = %d, saved length = %d'%(len(s),len(Test.objects.get(pk=t.id).long_text)) text length = 3998, saved length = 3998 text length = 3999, saved length = 3999 text length = 4000, saved length = 4000 text length = 4001, saved length = 2001 text length = 4002, saved length = 2002 I have seen this happen on an Oracle 10g (10.1.0) database running on a SUSE 9.3 (Kernal: 2.6.11.4-21.9-smp, Machine: x86) machine. Curiously I also ran the same test on a Windows XP Home machine using the free Oracle Express Edition and it ran just fine. The Oracle Express Edition that I am using is: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production It seems that the problem is isolated to the database running on the linux machine for I have manually tested the following combinations. Django on Linux + Oracle on Linux : Fail Django on WinXP + Oracle on Linux : Fail Django on Linux + Oracle on WinXP : Pass Django on WinXP + Oracle on WinXP : Pass Given the result of this investigation, my gut tells me that the problem lies in some configurable part of the Oracle installation that is running on Linux however I have no idea what this could be because from what I can see both instances of the database are "identical". Unfortunately I don't have another Linux box on which to test this to find out if it is just this one installation that is playing up. Has anyone else encountered a similar problem or have any thoughts on how I could get to the bottom of this mystery? Kind Regards Ben --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-developers?hl=en -~----------~----~----~----~------~----~------~--~---
