将十六进制值插入到mysql中 [英] inserting hex value into mysql

问题描述

有什么办法可以在MYSQL中插入十六进制值？
我也希望能够以十六进制形式检索它。

例如，
INSERT INTO table（hexTag）
VALUES（HEX（0x41））;

如果我这样做，我希望它在表格中放入'A'$ b $对于那个特殊的用例，你可以直接插入十六进制值，它会被解释为一个字符串，或者使用HEX（）来输入和UNHEX （）来输出

 
 mysql> create table hexTable（pseudoHex varchar（50））; 
 Query OK，0 rows affected（0.01 sec）
 
 mysql> insert into hexTable values（0x41）; 
 Query OK，1 row affected（0.00 sec）
 
 mysql> select * from hexTable; 
 + ----------- + 
 | pseudoHex | 
 + ----------- + 
 | A | 
 + ----------- + 
 1行设置（0.00秒）
 
 mysql>从hexTable中选择HEX（pseudoHex） 
 + ---------------- + 
 | HEX（pseudoHex）| 
 + ---------------- + 
 | 41 | 
 + ---------------- + 
 1行设置（0.00秒）
 
 mysql> delete from hexTable; 
 Query OK，1 row affected（0.00 sec）
 
 mysql> insert into hexTable values（HEX（'A'））; 
 Query OK，1 row affected（0.00 sec）
 
 mysql>从hexTable中选择UNHEX（pseudoHex） 
 + ------------------ + 
 | UNHEX（pseudoHex）| 
 + ------------------ + 
 | A | 
 + ------------------ + 
 1行设置（0.00秒）
 
 mysql> select * from hexTable ; 
 + ----------- + 
 | pseudoHex | 
 + ----------- + 
 | 41 | 
 + ----------- + 
 1行（0.00秒）
 

请参阅这些 链接。

Can there any way to insert a hex value into MYSQL? I also want to be able to retreive it in hex form.

For example, something like: INSERT INTO table ( hexTag ) VALUES ( HEX(0x41) );

And if I do this, I want it to put an 'A' into the table

解决方案

For that particular use case, you can either insert the hex value directly and it will be interpreted as a string, or use HEX() to input and UNHEX() to output

mysql> create table hexTable(pseudoHex varchar(50));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into hexTable values (0x41);
Query OK, 1 row affected (0.00 sec)

mysql> select * from hexTable;
+-----------+
| pseudoHex |
+-----------+
| A         |
+-----------+
1 row in set (0.00 sec)

mysql> select HEX(pseudoHex) from hexTable;
+----------------+
| HEX(pseudoHex) |
+----------------+
| 41             |
+----------------+
1 row in set (0.00 sec)

mysql> delete from hexTable;
Query OK, 1 row affected (0.00 sec)

mysql> insert into hexTable values (HEX('A'));
Query OK, 1 row affected (0.00 sec)

mysql> select UNHEX(pseudoHex) from hexTable;
+------------------+
| UNHEX(pseudoHex) |
+------------------+
| A                |
+------------------+
1 row in set (0.00 sec)

mysql> select * from hexTable;
+-----------+
| pseudoHex |
+-----------+
| 41        |
+-----------+
1 row in set (0.00 sec)

See these links.

这篇关于将十六进制值插入到mysql中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！