Re: Tough c++/Oracle Question???

I understand the insert I did better now. I thought that the value[0] || value[1] || ... would actually concatenate the bytes of value [0] and value[1]...for example.

value[0] = 1
value[1] = 2
value = hex 0x0201 = 513
This is not the case. The value saved in to field is 12.

I need to save a 128+bit value to a NUMERIC field and them extract it.

"DCCoolBreeze" <aa_at_bb.net> wrote in message news:9po4g5$as9$1_at_bob.news.rcn.net...
> I am using this value (192-bit one-way unique hash value) as the primary
> key. I will be working with over a billion records each day so I want it
 to
> be as fast as possible. Therefore, I did not use 3 numeric fields so I
> concatenate the array to be able to input it into the single numeric field
> but I cannot figure out how to get it back out :o(
>
> "Bradley Crockett" <bcrockett_at_altavista.net> wrote in message
> news:ElMv7.53823$L8.14949440_at_news2.rdc1.bc.home.com...
> > In article <9po2bi$r1$1_at_bob.news.rcn.net>, aa_at_bb.net says...
> > >
> > >1. I have a table in Oracle that contains a NUMERIC field
> > >2. I INSERT the variable unsigned long long llValue[3] into
> > > the numeric field by INSERT ....
> > > Values(llValue[0] | llValue[1] | llValue[2]);
> >
> > I don't understand what you've done here. Why do you have a pipestem
 between
> > each array element? Are you trying to concatenate or is that a
 delimiter?
> >
>
>
Received on Mon Oct 08 2001 - 22:50:59 CEST