Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2021 04:21 PM
@Derk Crezee - I learned something today. Apparently ODBC does not convert to JSON. There is no defined spec on how to return complex types, in fact that was added only in SQL 2016. That's exactly what you are running into!
End of history lesson 😄 Here's a fix:
SELECT to_json(nested)
FROM default.quotes_issueThis will return:
{"nested_column":"nested with a \" character"} which is valid JSON.