Error: The Server encountered an error processing result data

Knowledge Drop

Last tested: Aug 17, 2020

If you run into this error when using sql runner, check to see whether one of the columns you are querying is of type: binary. Sql runner can’t query binary data, so to get the columns through we can cast as varchar or string.

You can vote on this feature request: Use SQL Runner with Binary Type Data