Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #755 > unrolled thread
| Started by | NewtoOrcl <newtoorcl@yahoo.com> |
|---|---|
| First post | 2011-10-27 13:28 -0400 |
| Last post | 2011-10-27 23:22 +0200 |
| Articles | 4 — 3 participants |
Back to article view | Back to comp.databases.ms-sqlserver
Raw data NewtoOrcl <newtoorcl@yahoo.com> - 2011-10-27 13:28 -0400
Re: Raw data Gene Wirchenko <genew@ocis.net> - 2011-10-27 11:05 -0700
Re: Raw data NewtoOrcl <newtoorcl@yahoo.com> - 2011-10-27 17:41 -0400
Re: Raw data Erland Sommarskog <esquel@sommarskog.se> - 2011-10-27 23:22 +0200
| From | NewtoOrcl <newtoorcl@yahoo.com> |
|---|---|
| Date | 2011-10-27 13:28 -0400 |
| Subject | Raw data |
| Message-ID | <j8c4ck$nbg$1@speranza.aioe.org> |
I am trying to get the utl_raw.cast_from_number function to pass data to a 3rd party application. I am kind of confused as to how it gets converted into a binary format. Are these hexadecimal values? Why do the results vary so much in their length? 100 C202 200 C203 300 C204 400 C205 500 C206 1000 C20B 10000 C302 100000 C30B 1.2 C10215
[toc] | [next] | [standalone]
| From | Gene Wirchenko <genew@ocis.net> |
|---|---|
| Date | 2011-10-27 11:05 -0700 |
| Message-ID | <aq6ja7plj4hdhdeh4us9ej5iuiekmh1npf@4ax.com> |
| In reply to | #755 |
On Thu, 27 Oct 2011 13:28:54 -0400, NewtoOrcl <newtoorcl@yahoo.com>
wrote:
>I am trying to get the utl_raw.cast_from_number function to pass data to
>a 3rd party application. I am kind of confused as to how it gets
>converted into a binary format. Are these hexadecimal values? Why do
>the results vary so much in their length?
>100 C202
>200 C203
>300 C204
>400 C205
>500 C206
>1000 C20B
>10000 C302
>100000 C30B
>1.2 C10215
What are these values? Is one the result of applying a function
to the other?
They might be hexadecimal be though 1.2 is unusual. It is also
possible that the values for either column are not numeric.
Why do decimal numbers vary so much in their length? Sometimes,
more digits are required.
Sincerely,
Gene Wirchenko
[toc] | [prev] | [next] | [standalone]
| From | NewtoOrcl <newtoorcl@yahoo.com> |
|---|---|
| Date | 2011-10-27 17:41 -0400 |
| Message-ID | <j8cj6p$1cu$1@speranza.aioe.org> |
| In reply to | #756 |
On 10/27/2011 2:05 PM, Gene Wirchenko wrote: > Sincerely, > > Gene Wirchenko This was meant for the Oracle group - a mistake on my part that I have since corrected. Sorry for the confusion.
[toc] | [prev] | [next] | [standalone]
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Date | 2011-10-27 23:22 +0200 |
| Message-ID | <Xns9F8BEDBBE4EE7Yazorman@127.0.0.1> |
| In reply to | #755 |
NewtoOrcl (newtoorcl@yahoo.com) writes: > I am trying to get the utl_raw.cast_from_number function to pass data to > a 3rd party application. I am kind of confused as to how it gets > converted into a binary format. Are these hexadecimal values? Why do > the results vary so much in their length? > > > 100 C202 > 200 C203 > 300 C204 > 400 C205 > 500 C206 > 1000 C20B > 10000 C302 > 100000 C30B > 1.2 C10215 I had never heard of this utl_raw.cast_from_number function before, so I searched for it on Google. It appears that this is a function in Oracle, so you are in the wrong newsgroup. I suggest that you try comp.databases.oracle instead. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-sqlserver
csiph-web