E-book: A Practical Guide to AI and Vector Search in Relational Databases
Read Now
LogoLogo
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 context
  • MariaDB Server Documentation
  • Quickstart Guides
  • Server Usage
  • Server Management
  • Security
  • Architecture
  • Clients & Utilities
  • HA & Performance
  • Reference
    • 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
Powered by GitBook
On this page
  1. Reference
  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 TypesBINARYBLOBCHARCHARACTERCHAR BYTECHAR VARYINGCLOBENUMINET4INET6JSON Data TypeLONG and LONG VARCHARLONG CHAR VARYINGLONG CHARACTER VARYINGLONG VARBINARYLONG VARCHARLONG VARCHARACTERLONGBLOBLONGTEXTMEDIUMBLOBMEDIUMTEXTNATIONAL CHARNATIONAL CHAR VARYINGNATIONAL CHARACTER VARYINGNATIONAL CHARACTERNATIONAL VARCHARNATIONAL VARCHARACTERNCHARNCHAR VARCHARNCHAR VARCHARACTERNCHAR VARYINGRAWROWSET Data TypeTEXTTINYBLOBTINYTEXTUUID Data TypeVARBINARYVARCHARVARCHAR2VARCHARACTERCharacter Sets and Collations
PreviousYEAR Data TypeNextBLOB and TEXT Data Types

Last updated 7 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

© 2025 MariaDB. All rights reserved.

Was this helpful?