Re: UTL_RAW binary encoding - 2
From: neilsolent <n_at_solenttechnology.co.uk>
Date: Tue, 16 Jul 2013 07:10:55 -0700 (PDT)
Message-ID: <ed2eadc3-53b4-4ac9-a5d3-1a46d7751bef_at_googlegroups.com>
Thanks for your post.
Date: Tue, 16 Jul 2013 07:10:55 -0700 (PDT)
Message-ID: <ed2eadc3-53b4-4ac9-a5d3-1a46d7751bef_at_googlegroups.com>
Thanks for your post.
>
> Why? There's utl_raw.cast_from_number:
Because, in my C client, I need to convert the NUMBER column in Oracle (which will be an unsigned integer) into an array of 8 bytes. For example, I need to arrive at the string of 8 bytes "0 0 0 0 0 0 0 1" to represent the number 1 in this column in Oracle, etc.
2147483648 in hex is 0x80000000, not C51630312531 as reported by UTL_RAW.CAST_FROM_NUMBER()
I don't know where C5 comes from or what this output really means. My question is - how do I arrive at this 8 byte unsigned binary formatting, within Oracle.
thanks Received on Tue Jul 16 2013 - 16:10:55 CEST