MISCELLANEOUS DATA TYPES

• NCHAR(SIZE)
• NVARCHAR(SIZE)
• BOOLEAN
• LOB(large object)

1.NCHAR(SIZE):  It stands for Nationalized Character of fixed line support all kinds of International
                              Language Contents.
                              The Maximum length of Data Characteristics is 1 to 2000 characters
.
2.NVARCHAR2(SIZE):  It stands for Nationalized Variable Character and Maximum size of this                                                data type is 1 to 4000 characters.

3.BOOLEAN: This Data Type Enables to represent logical Values i.e., either TRUE or FALSE.

4.LOB: Large Objects are set of data types that are designed to hold large amount of data.
             A large object can hold up to a maximum of ranging from 8 TB to 128 TB, depending on                    how our databases completed.
             Storing Data LOB's enables to access & manipulate the data efficiently in your application.
It is further divided into 3 Types:
*CLOB
*BLOB
*BFILE

*CHARACTER  LARGE  OBJECTS(CLOB):
      This Data Type allows us to enter all kinds of Values such as Alphabets,Alphanumeric.
      The Maximum size is 1 to 4 GB

*BINARY LARGE OBJECT(BLOB):
     This Data Type allows us to enter any kind of data in binary format it can be used for Multimedia        data such as images,audios etc.,
     The Maximum number of Data size is 1 to 4 GB

*BINARY FILE:
    A Binary File stored outside the Database in the host operating system such as Files,Binary files.
    The Maximum size is 1 to 4 GB