mysql8报错 [42000][1064] ，使用DATE_FORMAT做为返回值的时候出错，字符集已经默认是UTF-8

Question

delimiter $
create function newdate()
returns varchar (20)
begin
return DATE_FORMAT(NOW(),'%m-%d-%Y');
end $

创建函数，系统报错

[2020-03-15 14:45:49] [42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return DATE_FORMAT(NOW(),'%m-%d-%Y')' at line 1

Answer 1

MySQL的utf-8不是真正的utf-8
需要用的是一个叫utf-8 mb64的字符集