8.20. SQLAlchemy Model Types

  • Strings: String, Text, Unicode, UnicodeText

  • Numerics: Numeric, Integer, SmallInteger, BigInteger, Float, Boolean

  • Enumerations: Enum

  • Blobs: LargeBinary

  • Dates: DateTime, Date, Time, Interval

8.20.1. SetUp

>>> from sqlalchemy.sql import sqltypes

8.20.2. String Types

  • String

  • Text

  • Unicode

  • UnicodeText

8.20.3. Numeric Types

  • Numeric

  • Integer

  • SmallInteger

  • BigInteger

  • Float

  • Boolean

8.20.4. Enumeration Types

  • Enum

8.20.5. Blob Types

  • LargeBinary

8.20.6. Date Types

  • DateTime

  • Date

  • Time

  • Interval

8.20.7. Other

  • DATE

  • TIME

  • TIMESTAMP

  • DATETIME

  • BOOLEAN

  • CLOB

  • BLOB

  • BINARY

  • VARBINARY

  • LARGEBINARY