Hi Guys
we dont usually come across columsn of this type. so just noting some facts
CLOB- Character large object it can store upto 4 GB.It can store any text files which are in character set supported by database .Like you cant store japanese files if you db only supports english character set.
BLOB- Binary large object -max size 4gb it can store images , audio , video .So can you store your favourite movie in oracle an just query it when required ..I will try this
What is character set
Numeric codes represent characters and character set determines what lanaguage you can store.
In ASCI every character has hexadecimal value
1-- 21
#-- 23
2--32
Hindi , english , german latn has 1 byte character set as they have at max 256 characters but language like japanes and chinese has more than 10,000 characters so they have different character set.
so amount of space it takes to store chinese , japanese characters is different from the bytes it takes to store english characters
we dont usually come across columsn of this type. so just noting some facts
CLOB- Character large object it can store upto 4 GB.It can store any text files which are in character set supported by database .Like you cant store japanese files if you db only supports english character set.
BLOB- Binary large object -max size 4gb it can store images , audio , video .So can you store your favourite movie in oracle an just query it when required ..I will try this
What is character set
Numeric codes represent characters and character set determines what lanaguage you can store.
In ASCI every character has hexadecimal value
1-- 21
#-- 23
2--32
Hindi , english , german latn has 1 byte character set as they have at max 256 characters but language like japanes and chinese has more than 10,000 characters so they have different character set.
so amount of space it takes to store chinese , japanese characters is different from the bytes it takes to store english characters
No comments:
Post a Comment