Re: endian prder in binary data

I would also be interested in your answer to Telemachus's question, since I'm looking at the effect of machine endianness on data storage in Oracle memory recently. The question is simply, can the vendor give you the exact procedure to show the data presentation problem due to different endianness? If you can get a small test case, that'll be great.

Yong Huang

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:<auAla.175270$Zo.33586_at_sccrnsc03>...
> They said they are using OCI as the interface. Not sure what you mean by
> method? Do you mean putting binary data in a character column?
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can figure
> it out.
> "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
> news:eDwla.8047$pK2.9358_at_news.indigo.ie...
> > Have they told you what method they're using to select/insert the data
> from
> > the application server ?
> > "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message
> > news:Pxsla.436830$S_4.499081_at_rwcrnsc53...
> > > Lets say I have a column of a raw or a blob. Lets say it is Oracle
> version
> > > 8.1.7.4 and is running on a Sun Solaris box. Lets say the client is
> running
> > > on Windows 2000. I am very sure that no matter that the client (w2k)
> and
> > > the server (Sun) are different endian architectures that the sqlnet will
> > > take care of the correct endian order.
> > >
> > > Why am I asking this? A vendor I deal with claims that since they are
> > > storing binary data in the database the application server (the client)
> and
> > > the database server (Oracle) must be on the same OS otherwise the endian
> > > problem. In the over ten years I've been working with Oracle and other
> > > RDBMSs I've never heard of such a problem. I think the vendor is
> shining
> me
> > > on. But hey I could be wrong.
> > >
> > > Thanks,
> > > Jim
Received on Thu Apr 17 2003 - 23:13:42 CDT