Version Information

Server Version:2.9.0
CLI Version (for CLI related issue):2.9.0

Environment

OSS

What is the current behaviour?

We have a sql database connected to hasura with a Danish_Norvegian_CI_AI collation.
In this database there are some columns with norwegian characters(ø, ...), column name for ex. is Fødeland
When we create an event trigger on that table with columns with this characters, it fires but does not deliver anything. The error in hasura logs is:
{"detail":{"code":"unexpected","error":"payload decode failed while fetching MSSQL events","path":"$"},"level":"error","timestamp":"2022-08-05T07:07:15.391+0000","type":"event-trigger"}

What is the expected behaviour?

It should deliver data without a restriction on collation of a databse.

How to reproduce the issue?

1. Create a database in sql server with a Danish_Norvegian_CI_AI collation
2. Add table, add column with a norvegial special characters in its name(like Fødeland)
3. Add trigger on update to that column
4. Fire a trigger by updating this column value

Screenshots or Screencast

Please provide any traces or logs that could help here.

Any possible solutions?

The nearly exact bug was resolved for a columns in 2.5.0 version (before it we cannot do a mutations on a columns with some special characters(norwegian letters))

Can you identify the location in the source code where the problem exists?

no

If the bug is confirmed, would you be willing to submit a PR?

no

Keywords

event, trigger, collation, mssql, payload