Execute Query: Unknown SQL type - 0

Help
1

Hi everybody, my question is about activity Execute Query, i get error with one field data json, it’s error Execute Query: Unknown SQL type - 0. Thacks for help me

2

Hi @Juan_Carlos_Salazar

Most of the time this error is thrown because the JSON data type is not supported by the ODBC driver. Its bit difficult to work with such data types along with databases because of driver compatibility. My answer is supported by this link.

https://forums.mysql.com/read.php?37,650722,651027#msg-651027

I would suggest to pass the json as a varchar data type. This could help to get rid of the error.

Let know whether it works out for you