Getting HEX from VARBINARY column in Flink SQL

[Graham Johnson]

Hi,

When I use the sql-client to query data on a topic which has one column with 
binary data in, the results show that column in hexadecimal format. Is there a 
way for me to get the data in that format in a SELECT statement? The Binary is 
not text, just an arbitary set of bytes. I want to be able to query various 
bytes within each row of data, for example checking if the 4th byte = 0xFF.

Thanks,

Graham
[https://www.microlise.com/wp-content/uploads/2021/02/spacer.png]
Microlise Service Desk: Visit the Customer Support 
Portal<https://microlise.service-now.com/csm>
Microlise Support Tel: 01773 537474
TruTac Support Tel: 02476 857890
Enterprise Software Systems (ESS) Support Tel: 0161 925 2424

Registered Office
Microlise Limited, Farrington Way, Eastwood
Nottingham, NG16 3AG
Tel: 01773 537000 | Fax: 01773 537373
Email: enquir...@microlise.com<mailto:enquir...@microlise.com>
Web: www.microlise.com<https://www.microlise.com>
[https://www.microlise.com/wp-content/uploads/2024/06/Microlise_Limited_GB_English_2023_Certification_Badge.png]<https://www.greatplacetowork.co.uk/workplace/item/6155/Microlise+Limited>[https://www.microlise.com/wp-content/uploads/2021/02/spacer.png][https://www.microlise.com/wp-content/uploads/2024/06/Microlise-Logo-Impact-Midnight.png]<https://www.microlise.com>
[https://www.microlise.com/wp-content/uploads/2021/02/spacer.png]
[Microlise Transport 
Conference]<https://microliseconference.ecreg.uk/?utm_source=Email&utm_medium=Footer>
[https://www.microlise.com/wp-content/uploads/2021/02/spacer.png]
This email and any files transmitted with it are confidential and intended 
solely for the individual or entity to whom they are addressed. If you have 
received this email in error please notify the sender and delete it 
immediately. Any disclosure, copying, distribution, or any action taken or 
omitted is to be taken in reliance on it is prohibited and may be unlawful. 
Please note any views or opinions presented in this email message are solely 
those of the author and do not necessarily represent those of the Microlise 
Group unless otherwise specifically stated.

Microlise Group plc - Registered in England and Wales No. 11553192