Re: UTL_RAW binary encoding - 2

From: neilsolent <>
Date: Tue, 16 Jul 2013 07:10:55 -0700 (PDT)
Message-ID: <>

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

Original text of this message