circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Watch Nowarrow-up-right
LogoLogo
search
⌘Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good evening

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guides
  • tvServer Usage
  • gearServer Management
  • shield-halvedSecurity
  • house-blankArchitecture
  • wrenchClients & Utilities
  • chart-mixedHA & Performance
  • paperclipReference
    • SQL Structure
    • SQL Statements
    • SQL Functions
    • Data Types
      • Data Type Storage Requirements
      • AUTO_INCREMENT
      • AUTO_INCREMENT FAQ
      • NULL Values
      • ROW TYPE OF
      • SERIAL
      • TYPE OF
      • Numeric Data Types
        • Numeric Data Type Overview
        • BIGINT
        • BIT
        • BOOL
        • BOOLEAN
        • DEC, NUMERIC, FIXED
        • DEC
        • DECIMAL
        • DOUBLE PRECISION
        • DOUBLE
        • FIXED
        • FLOAT
        • FLOAT4
        • FLOAT8
        • Floating-point Accuracy
        • INT
        • INT1
        • INT2
        • INT3
        • INT4
        • INT8
        • INTEGER
        • MEDIUMINT
        • MIDDLEINT
        • NUMBER
        • NUMERIC
        • REAL
        • SMALLINT
        • TINYINT
      • Date and Time Data Types
      • String Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
    • Product Development
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. paperclipReferencechevron-right
  2. Data Types

Numeric Data Types

Complete numeric types reference: INT/BIGINT ranges, DECIMAL(M,D) precision/scale, FLOAT/DOUBLE storage sizes, and numeric type selection guidelines.

Numeric Data Type Overviewchevron-rightBIGINTchevron-rightBITchevron-rightBOOLchevron-rightBOOLEANchevron-rightDEC, NUMERIC, FIXEDchevron-rightDECchevron-rightDECIMALchevron-rightDOUBLE PRECISIONchevron-rightDOUBLEchevron-rightFIXEDchevron-rightFLOATchevron-rightFLOAT4chevron-rightFLOAT8chevron-rightFloating-point Accuracychevron-rightINTchevron-rightINT1chevron-rightINT2chevron-rightINT3chevron-rightINT4chevron-rightINT8chevron-rightINTEGERchevron-rightMEDIUMINTchevron-rightMIDDLEINTchevron-rightNUMBERchevron-rightNUMERICchevron-rightREALchevron-rightSMALLINTchevron-rightTINYINTchevron-right
PreviousTYPE OFchevron-leftNextNumeric Data Type Overviewchevron-right

Last updated 8 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2026 MariaDB. All rights reserved.

Was this helpful?