Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forumdisplay.php?f=39)
-   -   what type is allowed for oracle BLOB (http://www.go4expert.com/showthread.php?t=867)

prashantSum 5Jun2006 15:17
what type is allowed for oracle BLOB
 
what type of data is allowed for blob?

Is it only 0's and 1's as the name implies.

but I am able to insert 0-9 and a-f through sql* plus. why is it so?

shabbir 6Jun2006 04:38
Re: what type is allowed for oracle BLOB
 
Quote:
Originally Posted by prashantSum
but I am able to insert 0-9 and a-f through sql* plus. why is it so?
Its not restricted to 0's and 1's but its the way they are stored. 0-9 and a-f can also be represented in 0's and 1's form and stored in that fashion.

prashantSum 6Jun2006 10:57
Re: what type is allowed for oracle BLOB
 
thanks for the reply,

I am unable to insert data other than 0-9 and a-f into BLOB, as it is giving 'ORA-00911: invalid character' message.
So does it only allow Hexadecimal numbers.

If so, why it is allowing Hexadecimal numbers when it's name is Binary LOB?

And one more thing when I take a word document as InputStream through JDBC and insert it into BLOB how I am able to insert word document into BLOB, as word document contains characters other than 0-9 and a-f.

I am not getting low level clarity as how data is managed in BLOB, can you give some clarity on this.

shabbir 6Jun2006 11:35
Re: what type is allowed for oracle BLOB
 
Quote:
Originally Posted by prashantSum
I am unable to insert data other than 0-9 and a-f into BLOB, as it is giving 'ORA-00911: invalid character' message.
So does it only allow Hexadecimal numbers.
Actually it allows the characters represented in the Hex form and not only the Hex characters. Even Z can be represented as binary value and has a Hex equivalent.
Quote:
Originally Posted by prashantSum
If so, why it is allowing Hexadecimal numbers when it's name is Binary LOB?
Because there is a relation between Hex and binary and hex is just a way to represent binary data in a convenient manner.
Quote:
Originally Posted by prashantSum
And one more thing when I take a word document as InputStream through JDBC and insert it into BLOB how I am able to insert word document into BLOB, as word document contains characters other than 0-9 and a-f.
Because you are representing each bytes into binary values.

mikestewart 25Jul2006 02:51
Re: what type is allowed for oracle BLOB
 
Me too I would like to know aswell

mikestewart 25Jul2006 02:53
Re: what type is allowed for oracle BLOB
 
Quote:
Originally Posted by prashantSum
thanks for the reply,

I am unable to insert data other than 0-9 and a-f into BLOB, as it is giving 'ORA-00911: invalid character' message.
So does it only allow Hexadecimal numbers.

If so, why it is allowing Hexadecimal numbers when it's name is Binary LOB?

And one more thing when I take a word document as InputStream through JDBC and insert it into BLOB how I am able to insert word document into BLOB, as word document contains characters other than 0-9 and a-f.

I am not getting low level clarity as how data is managed in BLOB, can you give some clarity on this.
Me too I would like to know aswell

mikestewart 25Jul2006 03:10
Re: what type is allowed for oracle BLOB
 
Quote:
Originally Posted by prashantSum
thanks for the reply,

I am unable to insert data other than 0-9 and a-f into BLOB, as it is giving 'ORA-00911: invalid character' message.
So does it only allow Hexadecimal numbers.

If so, why it is allowing Hexadecimal numbers when it's name is Binary LOB?

And one more thing when I take a word document as InputStream through JDBC and insert it into BLOB how I am able to insert word document into BLOB, as word document contains characters other than 0-9 and a-f.

I am not getting low level clarity as how data is managed in BLOB, can you give some clarity on this.
ooo

shabbir 25Jul2006 04:31
Re: what type is allowed for oracle BLOB
 
Quote:
Originally Posted by mikestewart
Me too I would like to know aswell
Try http://ora-00911.ora-code.com/


All times are GMT +5.5. The time now is 04:37.