Jayraj Chhaya
What is BLOB and TEXT in MySQL

What is BLOB and TEXT in MySQL

By Jayraj Chhaya in MySQL on Jan 25 2024
  • Alpesh Maniya
    Jan, 2024 29

    In MySQL:1. **BLOB (Binary Large Object):**- Stores binary data like images or audio.- Suitable for multimedia files.- Example: `BLOB` field in a table.2. **TEXT:**- Stores large amounts of character data.- Suitable for text-based content like articles.- Types include `TINYTEXT`, `TEXT`, `MEDIUMTEXT`, `LONGTEXT`.- Example: `TEXT` field in a table.

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS