drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject UTF coding in JSON docs
Date Tue, 03 Mar 2015 02:23:52 GMT
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).

View raw message