Kolja Kleist wrote:
> 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?
ok, was done and will be available with the next kernel version.
It is named as in Oracle: HEXTORAW
Elke
SAP Labs Berlin
> -----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
