Home > database >  Mysql char () function returns the hex value question
Mysql char () function returns the hex value question

Time:10-18

Dear bosses, the younger brother novice, according to the tutorial to use char () function outputs a special character,

The select char (97);

Arguably should be returned directly. A, but the results returned to the zero x61

Have bosses to know why? Baidu a circle didn't find the same situation

But using the ASCII function was no problem

CodePudding user response:

Try, as long as the function contains the char () function will return into hexadecimal,
Such as concat (' a ', char (97)), the output is 0 x6161
If use the concat (' a ', 'a'), is no problem
  • Related