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

[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

[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 ...