mysql text concat,MySQL CONCAT（" string" longtext）产生十六进制字符串

I'm experiencing a weird hex string result when trying to concat a string with a column that should be of LONGTEXT type.

The query goes like this:

SELECT concat("abc",t.LONGTEXT_VALUE,"cde") FROM mytable t

61626354657374696e67636465

The hex string 61626354657374696e67636465 is the correct value, just in hexadecimal form.

A SELECT on the column itself will return the normal string:

SELECT t.LONGTEXT_VALUE FROM mytable t

Testing

解决方案

Have you tried casting? Usually works pretty well for me. Example:

SELECT CONCAT("abc",CAST(t.LONGTEXT_VALUE AS CHAR),"cde") FROM mytable t