Hi all, I have a question about best practices with storing strings in an Oracle DB. I've grown accustomed to using TextFields wherever possible, as I mainly work in Postgres and this seems to be recommended:
http://stackoverflow.com/questions/7354588/django-charfield-vs-textfield However, I'm trying to migrate a project to Oracle and finding that my TextFields are now being stored as CLOBs. This is not really ideal, as I can't use them (easily) in SQL queries and it just seems like overkill for short, variable-length strings. If I weren't using Django I would store these as varchars, and I guess I could make them all CharFields, but I hate to have my models be so closely coupled to the DB. Has anyone else come up with a more elegant solution for this? Would CharField(max_length=255) be a good compromise? Thanks! -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b279f66f-a55f-4d23-b147-0b945b41df20%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
