-
Notifications
You must be signed in to change notification settings - Fork 20
Description
Hi, I have a VARBINARY column in my table. I'm able to INSERT the data into table/column (as byte[]) but while reading I'm getting it as some string and not able to identify how to read the same & convert back to byte[]. Need help in sharing proper steps (either insert or read) or identify if its potential issue in client.
Tried with both trino client & ADO - but unable to read correctly
Using direct method trino client: tried following attempt
var times = Encoding.UTF8.GetBytes(row[6] as string); // The byte[] returned when to given to decompress I get exception.
Using ADO: getting below exception
var dataTable = await records.BuildDataTableAsync().ConfigureAwait(false);// Note: Invalid cast from 'System.String' to 'System.Byte[]'."
Thanks & Regards!