TestingDocs.com
    Software Testing website
    • Automation
      • Selenium
      • JBehave Framework
    • Tutorials
      • MySQL Tutorials
      • Testlink
      • Maven
      • Git
    • IDEs
      • IntelliJ IDEA
      • Eclipse
    • Flowcharts
      • Flowgorithm
      • Raptor
    • About

    MySQL

    MySQL String Data Types

    Overview

    In this tutorial, we will learn about MySQL String Data Types. Strings are an important data type. A String is used for storing character strings. A character string is a sequence of characters.

    String data types

    String data types provided in MySQL are as follows.

    • CHAR
    • VARCHAR
    • TINYTEXT
    • TEXT
    • MEDIUMTEXT
    • LONGTEXT

     

     

    String Data Type
    Description
    CHAR CHAR data type is for fixed-length strings. Fixed-length means that a string is stored using a fixed number of bytes. It is right-padded with spaces to the specified length when stored.
    VARCHAR VARCHAR data type is for variable-length strings. Variable-length stores the string value and string length together. The amount of storage space that VARCHAR uses depends on the number of characters in the string
    TINYTEXT TINYTEXT data type is for variable-length strings and allows up to a maximum of 255 characters
    TEXT The TEXT data type is used for variable-length strings and allows up to a maximum of 65,535 characters
    MEDIUMTEXT MEDIUMTEXT data type is for variable-length strings and allows up to a maximum of 16,777,215 characters
    LONGTEXT LONGTEXT data type is for variable-length strings and allows up to a maximum of 4,294,967,295 characters. The maximum permitted length depends on the client/server protocol

     

     

    —

    MySQL Tutorials

    MySQL Tutorials on this website:

    https://www.testingdocs.com/mysql-tutorials-for-beginners/

    For more information on MySQL Database:

    https://www.mysql.com/

    Related Posts

    Stellar Converter for Database Tool

    MySQL /

    Stellar Converter for Database

    Stellar MySQL Log Analyzer

    MySQL /

    Stellar Log Analyzer for MySQL

    Stellar Repair for MySQL

    MySQL /

    Stellar Repair for MySQL

    MySQL /

    How to secure your SQL Database: Tips and Tricks

    Stellar Converter for Database

    MySQL /

    Database Converter Tools

    ‹ MySQL REVERSE Function› MySQL Numeric Data types

    Recent Posts

    • ChatGPT Plans Free and PlusChatGPT Subscription Plans
    • Stellar Converter for Database ToolStellar Converter for Database
    • Stellar MySQL Log AnalyzerStellar Log Analyzer for MySQL
    • Stellar Repair for MySQLStellar Repair for MySQL
    • ChatGPT IntroductionChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI FeaturesChatGPT4 Conversational AI Features
    • Trends in Software EngineeringShaping the Future of Development: Exploring Key Trends in Software Engineering
    • Java PerformanceImproving Java Performance with Multithreading
    • QDrant Vector DatabaseOpen-source Vector Databases
    • Difference between PHP and JavaScript?
    • Bing AI Browser Web ContentBing Conversation Styles
    • ChatGPT PreviewChatGPT Introduction
    • Open Source AI Frameworks TensorFlowOpen Source AI Frameworks
    • Artificial Intelligence Tools

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com