Problems using syncdb with Oracle 10g - strange field names and null = false ignored

[anonymous]

Hello

When syncdbing the following model :

class IdentificationConfidence(models.Model):
        
        identification_confidence = models.CharField("how confident the observer is", max_length = 20, null = False)
        
        class Meta:
                app_label = 'interaction'
                
        def __unicode__(self):
                return self.identification_confidence

I get the following table produced:

INTERACTION_IDENTIFICATION8A86

with fields ID (PK) and

IDENTIFICATION_CONFIDENCE NVARCHAR2(20) Nullable = Yes

Syncdb seems to be ignoring null = false and providing a strange table name

Thanks

Catriona

NB I didn't type the the question marks into my issue - they just appeared and it was __unicode__

[Malcolm Tredinnick]

(Fixed wiki formatting in description.)

The modified table name is nothing to worry about. There's a maximum length on table names in Oracle, so we truncate them and a unique hash to the end.

The other bit (ignore null=False) is something I'll let the Oracle maintainers worry about.