you can write a udf to cast the binary data to string as you wish. best, Shengkai
Graham Johnson <graham.john...@microlise.com> 于2025年3月7日周五 22:21写道： > 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 4 > th byte = 0xFF. > > Thanks, > > Graham > *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 > Web: www.microlise.com > <https://www.greatplacetowork.co.uk/workplace/item/6155/Microlise+Limited> > <https://www.microlise.com> > [image: Microlise Transport Conference] > <https://microliseconference.ecreg.uk/?utm_source=Email&utm_medium=Footer> > 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 >
