On Aug 18, 6:54 pm, "arun.viswan...@gmail.com"
<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
I do not get the output you're reporting from the dump() function for
this data. Post all of the steps you use to create the table, load
and query the data so we can all have the same point of reference.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
