Collections:
Entering Characters as HEX Numbers in MySQL
How To Enter Characters as HEX Numbers in MySQL?
✍: FYIcenter.com
If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a character string, if the expression context is a string. Here are some good examples:
SELECT X'313233' FROM DUAL; 123 SELECT 0x414243 FROM DUAL; ABC SELECT 0x46594963656E7465722E636F6D FROM DUAL; FYIcenter.com
⇒ Entering Numeric Values as HEX Numbers in MySQL
⇐ Entering Numeric Values in MySQL
2018-03-31, 2247🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...