Rather than have someone guess how you are doing your inserts... Could you please show exactly what you are doing? In a case like this, the devil could be all in the details.
one thing I do remember from class a million years ago is that 10000000 is not 128 in any numeric representation that allows signed values. I will note that 127+64 = 191 ... for what that is worth. Binary representations of non-trivial data types are always entertaining, i try to avoid them unless there is a really good reason. Rob On Tue, August 18, 2009 19:54, arun.viswan...@gmail.com wrote: > > I'm storing the Binary Data in VARCHAR2 field. > > The Insert operation is successful and if i query the db using the > following query it is showing the Decimal data of that field > > Select DUMP(<field>) from table; > > o/p: 127,0,0 > Binary equivalent for it is : 01111111,00000000,00000000 > > This is an expected output. > > But if is store the binary equivalent of "128" in this field it is > storing in value equivalent to "191" > > Expected Output: 128,0,0 => 10000000,00000000,00000000 > O/p Got is: 191,0,0 -> And it is what stored in the DB. > > Please let me know under what representation Oracle stores the value > "128" and "191" in DB > > Thanks in Advance > Arun > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
