使用CONCAT时，Mysql位字面值不起作用 [英] Mysql bit literal not working when use CONCAT

问题描述

Mysql位文字。它工作正常，但在下面尝试使用CONCAT时不能正常工作



CHAR A =二进制01000001

 SELECT 0b01000001 FROM DUAL; 
 SELECT b'01000001'FROM DUAL; 

我尝试过：



制作CONCAT时不工作

 SET @ val1 ='0b'; 
 SET @ val2 = 01000001; 
 SET @ val3 = CONCAT（@ val1，@ val2）; 
 SELECT @ val3; 

解决方案

您正在尝试将字符串连接到字符串，这就是它无法正常工作的原因。您可以尝试这样的事情（未经测试）

  SET   @ val3  = CONCAT（ @ val1 ，CAST（val2  as  文本））; 

Hi, Mysql bit literal. Its working fine but not working when made CONCAT as tried below

CHAR A = Binary 01000001

SELECT 0b01000001 FROM DUAL;
SELECT b'01000001' FROM DUAL;

What I have tried:

Not working when made CONCAT

SET @val1 = '0b';
SET @val2 = 01000001;
SET @val3 = CONCAT(@val1,@val2);
SELECT @val3;

解决方案

You are trying to concatenate bit with string that's why it is not working. You may try something like this (not tested)

SET @val3 = CONCAT(@val1, CAST(val2 as text));

这篇关于使用CONCAT时，Mysql位字面值不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！