openresty/1.11.2.1 use resty-mysql query An error is invalid charset

[xuefeilong]

local ok, err, errno, sqlstate = db:connect(sql)
The return value：
ok ----> nil
err ----> invalid charset
errno ----> 1105
sqlstate ---> HY000

[anguslee]

Could you provide a minimal SQL example that returns this error? And have you checked the MySQL server log for more clues?

Hopefully this could help: https://dev.mysql.com/doc/refman/8.0/en/charset-errors.html