npm error when using typecast

[Thallius]

Hi,

using typecast

typeCast: function (field, next) { if (field.type === 'JSON') { let c = field.string("utf8"); <= this is causing the warning if (c && c.toLowerCase() !== "[null]") return (JSON.parse(c)); else return []; } return next(); }

brings up npm error

typeCast: JSON column "MyColumnName" is interpreted as BINARY by default, recommended to manually set utf8 encoding: field.string("utf8")

For every query which contains a JSON_ARRAYAGG command.

This is spamming the logs so I really need to get rid of it

sorry do not know how to format the code correct

[Thallius]

So no one else has this problem and is interested in a solution?

[wellwelwel]

So no one else has this problem and is interested in a solution?

Hi @Thallius, please see the #2481 (comment) 🙋🏻‍♂️

[kym6464]

The workaround is to pass utf-8 instead of utf8. Looks like this was pointed out in the original PR but was ignored https://github.com/sidorares/node-mysql2/pull/1662/files#r1069381685