test env: sql server 2005 and pyodbc 3.0.7 and freetds 0.91, on debian 8.0 product env: sql server 2005 and pyodbc 3.0.7 and native client 10.0, on windows 2003 above two env is the same behavior with 0.9.1, always return decimal object for float type
follow is part data model: from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.schema import Column, from sqlalchemy.types import SmallInteger, Integer, Float from sqlalchemy.types import String Base = declarative_base() class Unit(Base): __tablename__ = 't_MeasureUnit' id = Column('FMeasureUnitID', Integer, autoincrement=False, primary_key=True) name = Column('FName', String(80), nullable=False) number = Column('FNumber', String(30), nullable=False) short_number = Column('FShortNumber', String(30)) conversation = Column('FConversation', Integer, server_default='(1)') coefficient = Column('FCoefficient', Float, nullable=False, server_default='(1)') deleted = Column('FDeleted', SmallInteger, nullable=False, server_default='(0)') with 0.8.4, conversation column return python float object, upgrade to 0.9 or 0.9.1 all Float column always return decimal object. my project and the data model has been running for over two years, pass two year with 0.7 and 0.8 no problem. my project not need to use decimal, float precision is sufficient. 在 2014年1月21日星期二UTC+8上午2时33分05秒,Michael Bayer写道: > > > 1. What database backend is this? > > 2. What does the CREATE TABLE for the table in question look like, as it > is present in the database? > > 3. Was the behavior the same with 0.8.4 ? > > > On Jan 20, 2014, at 12:31 PM, 曹忠 <joo....@gmail.com <javascript:>> wrote: > > qty = Column(Float(asdecimal=False), nullable=False, server_default='(0)') > > the qty always return decimal object, how to return the python float type > object? > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+...@googlegroups.com <javascript:>. > To post to this group, send email to sqlal...@googlegroups.com<javascript:> > . > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.