On Oct 30, 2008, at 6:52 PM, desmaj wrote:
> > On MSSQL the default nullableness of a column, when neither NULL or > NOT NULL are specified in the column definition, is configurable. The > MSSQL dialect produces ANSI standard SQL when creating tables. So when > a Column is specified with nullable=True, the DDL emitted contains > neither NULL or NOT NULL. If the database is not set to use the ANSI > null default, this produces unexpected results. > > I'm not sure what the policy is about things like this. Would you > welcome a patch that always explicitly applied either NULL or NOT NULL > to column definition DDL produces by the MSSQL dialect? It might lead > to some people being surprised by the behavior of their tables, but it > seems (to me) to be the best way to assure that there are no future > surprises. if MSSQL has some setting that causes no specification of NULL to result in NOT NULL, then yes SQLA should explicitly emit NULL, since nullable=True is our default. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---