Re: [sqlalchemy] What should be the preferred data type for primary key colum if in database(MSSQL) it is defined as Numeric(18,0)

2015-02-04 Thread Anurag Vaishwade
Thanks Michael for your suggestion. On Wednesday, February 4, 2015 at 8:09:15 PM UTC+5:30, Michael Bayer wrote: > > your tables already exist so stick with BigInteger.Doesn’t make much > difference on the client side. > > > > Anurag Vaishwade > wrote: > > > Hello Everyone, > >

Re: [sqlalchemy] What should be the preferred data type for primary key colum if in database(MSSQL) it is defined as Numeric(18,0)

2015-02-04 Thread Michael Bayer
your tables already exist so stick with BigInteger.Doesn’t make much difference on the client side. Anurag Vaishwade wrote: > Hello Everyone, > I am facing issues with defining table's primary key column > as Numeric(18,0).I am connecting to a MSSQL and in database all ta

[sqlalchemy] What should be the preferred data type for primary key colum if in database(MSSQL) it is defined as Numeric(18,0)

2015-02-03 Thread Anurag Vaishwade
Hello Everyone, I am facing issues with defining table's primary key column as Numeric(18,0).I am connecting to a MSSQL and in database all tables are defined as Numeric(18,0) for primary key. So to match with the database table schema I updated Sqlalchemy tables as Numeric(18,0)