Request GET /foo?filter=%7B%22where%22:%20%7B%22name%22:%20%7B%22regexp%22:%20%22/%5Efoo/%22%7D%7D%7D failed with status code 500. Error: UNKNOWN_CODE_PLEASE_REPORT: Character set 'utf8mb4_general_ci' cannot be used in conjunction with 'binary' in call to regexp_like.
at Query.Sequence._packetToError (/home/node/app/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/home/node/app/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/home/node/app/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/node/app/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/node/app/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/home/node/app/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/home/node/app/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/home/node/app/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (node:events:390:28)
at addChunk (node:internal/streams/readable:315:12)
Expected Behavior
Should return all regex matches for the selected model in the api response
Steps to reproduce
Current Behavior
results in an "500 Internal Server Error":
Expected Behavior
Should return all regex matches for the selected model in the api response
Additional information
it is probably this issue: https://stackoverflow.com/questions/64668364/character-set-binary-cannot-be-used-in-conjunction-with-utf8mb4-unicode-ci-i
node -e 'console.log(process.platform, process.arch, process.versions.node)' linux x64 16.13.1
npm ls --prod --depth 0 | grep loopback
+-- @loopback/boot@4.0.0 +-- @loopback/cli@3.0.0 +-- @loopback/core@3.1.2 +-- @loopback/repository@4.1.2 +-- @loopback/rest-crud@0.12.1 +-- @loopback/rest-explorer@4.0.0 +-- @loopback/rest@11.1.2 +-- @loopback/service-proxy@4.0.0 +-- loopback-connector-mysql@5.4.4