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
