Page 1 of 1

How can I translate CAST ( ... AS BINARY) into Firebird lang

Posted: 21.07.2008, 17:46
by Tommi
I used with mysql this syntax

CAST (0x... AS BINARY) but now with Firebird it doesn't work ?

How can I do ?

Thank you

Posted: 22.07.2008, 08:19
by Michael
Hi,

I don't think that FB provides this kind of conversion. But there is a UDF that contains a bunch of functions (abount 470). It is called FreeAdhocUDF and you can find it here: http://www.udf.adhoc-data.de/index_eng.html It contains two functions that might be interesting for you:
  • F_CONVERTTOBASE ... and
  • F_CONVERTFROMBASE
I never used this library but I hope this will help to solve your problem ... :wink: