How can I convert JSON data with various characters in a text field to a more usable UTF8 encoding? (even if characters not in UTF8 is dropped) Or if needs be filter out the records with characters not in UTF8?
CONVERT_TO is for binary and cast as varchar still passes these characters through. Results in sqlline works, but when using tools through ODBC various failures occur (especially tools not capable of handling characters outside of UTF8). Thanks —Andries
