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 morning

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
      • Date and Time Data Types
      • String Data Types
        • BLOB and TEXT Data Types
        • BINARY
        • BLOB
        • CHAR
        • CHARACTER
        • CHAR BYTE
        • CHAR VARYING
        • CLOB
        • ENUM
        • INET4
        • INET6
        • JSON Data Type
        • LONG and LONG VARCHAR
        • LONG CHAR VARYING
        • LONG CHARACTER VARYING
        • LONG VARBINARY
        • LONG VARCHAR
        • LONG VARCHARACTER
        • LONGBLOB
        • LONGTEXT
        • MEDIUMBLOB
        • MEDIUMTEXT
        • NATIONAL CHAR
        • NATIONAL CHAR VARYING
        • NATIONAL CHARACTER VARYING
        • NATIONAL CHARACTER
        • NATIONAL VARCHAR
        • NATIONAL VARCHARACTER
        • NCHAR
        • NCHAR VARCHAR
        • NCHAR VARCHARACTER
        • NCHAR VARYING
        • RAW
        • ROW
        • SET Data Type
        • TEXT
        • TINYBLOB
        • TINYTEXT
        • UUID Data Type
        • VARBINARY
        • VARCHAR
        • VARCHAR2
        • VARCHARACTER
        • Character Sets and Collations
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
    • Product Development
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. paperclipReferencechevron-right
  2. Data Types

String Data Types

Store text and binary data. This section covers character types like CHAR, VARCHAR, and TEXT, as well as binary types like BLOB and BINARY.

BLOB and TEXT Data Typeschevron-rightBINARYchevron-rightBLOBchevron-rightCHARchevron-rightCHARACTERchevron-rightCHAR BYTEchevron-rightCHAR VARYINGchevron-rightCLOBchevron-rightENUMchevron-rightINET4chevron-rightINET6chevron-rightJSON Data Typechevron-rightLONG and LONG VARCHARchevron-rightLONG CHAR VARYINGchevron-rightLONG CHARACTER VARYINGchevron-rightLONG VARBINARYchevron-rightLONG VARCHARchevron-rightLONG VARCHARACTERchevron-rightLONGBLOBchevron-rightLONGTEXTchevron-rightMEDIUMBLOBchevron-rightMEDIUMTEXTchevron-rightNATIONAL CHARchevron-rightNATIONAL CHAR VARYINGchevron-rightNATIONAL CHARACTER VARYINGchevron-rightNATIONAL CHARACTERchevron-rightNATIONAL VARCHARchevron-rightNATIONAL VARCHARACTERchevron-rightNCHARchevron-rightNCHAR VARCHARchevron-rightNCHAR VARCHARACTERchevron-rightNCHAR VARYINGchevron-rightRAWchevron-rightROWchevron-rightSET Data Typechevron-rightTEXTchevron-rightTINYBLOBchevron-rightTINYTEXTchevron-rightUUID Data Typechevron-rightVARBINARYchevron-rightVARCHARchevron-rightVARCHAR2chevron-rightVARCHARACTERchevron-rightCharacter Sets and Collationschevron-right
PreviousYEAR Data Typechevron-leftNextBLOB and TEXT Data Typeschevron-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?