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 -~----------~----~----~----~------~----~------~--~---
