
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
What is the default type of a hexadecimal value in MySQL?
As we know that in numeric contexts the hexadecimal values act like integers and in string contexts they act like binary string. It can be understood with the help of the following example,
mysql> Select X'5455544F5249414C53504F494E54'; +---------------------------------+ | X'5455544F5249414C53504F494E54' | +---------------------------------+ | TUTORIALSPOINT | +---------------------------------+ 1 row in set (0.07 sec)
But, if we are talking about default type of hexadecimal value in MySQL, then it is a string.
- Related Articles
- Set default value to a JSON type column in MySQL?
- What is the default type of a bit value assigned to user variables?
- How can I insert default value in MySQL ENUM data type?
- Is there a default ORDER BY value in MySQL?
- What is a default value in Python?
- What would be the default return type of MySQL IFNULL() control flow operator?
- What is the default value of a local variable in Java?\n
- How MySQL evaluates an empty hexadecimal value?
- What MySQL returns if we convert an empty hexadecimal value to a number?
- Hexadecimal literal of type long in Java
- What Is the Default MySQL Port Number?
- Adding a column whose value is not null by default in MySQL?
- What is the default sort order in MySQL tables?
- Reset MySQL field to default value?
- How to use a function for default value in MySQL?

Advertisements