String() needs a length with Oracle, MySQL, and several others.
On Feb 9, 2011, at 10:39 AM, Eduardo wrote:
> Hi,
> I want to create the following table:
>
> Table('Error', metadata,
> Column('Type', String),
> Column('reference', String),
> Column('context', String),
> Column ('Timestamp', DateTime, primary_key=True),)
>
> with the oracle DB. I receive this:
>
> sqlalchemy.exc.Error: (DatabaseError) ORA-00910: specified length too
> long for its datatype
> '\nCREATE TABLE "Error" (\n\t"Type" VARCHAR(None CHAR), \n
> \t"reference" VARCHAR(None CHAR), \n\t"context" VARCHAR(None CHAR), \n
> \t"Timestamp" DATE\n)\n\n' {}
>
> I tried it with the postgres it works.
> Is there any configuration option that makes the oracle accept this
> table without changing the given data types?
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> To unsubscribe from this group, send email to
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
