将十六进制值插入mysql
有什么方法可以将十六进制值插入MYSQL吗？ 我还希望能够以十六进制形式检索它。
例如，类似： 插入表（十六进制标签） 值（十六进制（0x41））；
如果我这样做，我希望它在表中添加一个“A”
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对于该特定用例，您可以直接插入十六进制值，它将被解释为字符串，或者使用 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 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)请参阅 这些 链接。
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.