The right solution is to go into the JSON format and somehow let character encoding be defined there.
On Tue, Mar 3, 2015 at 3:23 AM, Andries Engelbrecht < [email protected]> wrote: > 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
