Hallo Elke, thank you for the quick response. I have a web application that runs about 4 years with adabas/php. Switching to SQLMODE Oracle maybe brings a lot of other problems with it (??I really don't know??). Maybe you can discuss internaly, if it will be a lot of work to support the function HEXTORAW(or something like that) in SQLMODE internal for the future releases?
Regards, Kolja -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Zabach, Elke Gesendet: Montag, 27. Mai 2002 16:01 An: 'Kolja Kleist'; [EMAIL PROTECTED] Betreff: RE: Conversion from hex to byte Kolja Kleist wrote: > I have a problem with CHAR(8)BYTE key columns and conversion > from hex to > byte. > I use PHP 4 as interface and I want to prepare a statment > with a placeholder > for the key column. > Because php can't handle the datatype byte I use the hex() function to > select a key from the db. > To convert the HEX key back to byte I only know the > x'...'-function that > works only with constants. So I can't use it with prepared statements > (x'?'). With ADABAS I wrote my own function to do the > conversion but SAP DB > doesn't support function. > Has anyone an idea to solve this problem? Use the SQLMODE Oracle and the function HEXTORAW. BTW: x' ..' is no function. It is just to make syntax precise to tell everyone (incl the kernel) reading this: attention, a hex-value is following, no normal character value. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
