It should return VARBINARY value encoded in UTF8 that matches the binary
encoding one would expect. But I just realized there is actually an error
in what you wrote. The correct encoding is UTF8, not UTF-8. A recent fix
makes the error message much better here and will be included in 1.2.
So this works:
SELECT CONVERT_TO('[ [1, 2], [3, 4], [5]]' ,'UTF8') AS MYCOL1 FROM
sys.version;
+--------------+
| MYCOL1 |
+--------------+
| [B@7e308c04 |
+--------------+
On Wed, Jul 22, 2015 at 4:57 PM, Ted Dunning <[email protected]> wrote:
> On Wed, Jul 22, 2015 at 4:51 PM, Jacques Nadeau <[email protected]>
> wrote:
>
> > > SELECT CONVERT_TO('[ [1, 2], [3, 4], [5]]','UTF-8') AS MYCOL1 FROM
> > sys.version;
> >
> > File a bug. This should work.
>
>
> I would love to but I don't know what it should do.
>
> Note that the error messages in all of these cases were essentially
> incomprehensible.
>
