Forum Stats

  • 3,732,985 Users
  • 2,246,666 Discussions


Compare difference for data type BLOB between Data Model and Dictionary

Robert Huber
Robert Huber Member Posts: 180 Blue Ribbon

Using Synchronize Data Model with Dictionary leds to a difference when the data type of the column is BLOB. Because in the Data Model, it's BLOB, whereas in the Dictionary it's BLOB(21474883647), see attached screenshot.

Having asked this question earlier, David Last-Oracle gave the hint to uncheck the Size Checkbox in Tools > Type Administration for the logical type BLOB, which worked fine.

Unfortunately, not so any more with the ODM Version 21.1.092 (and may be earlier versions).

I am using as database SQL Anywhere 17 with the corresponding JDBC driver and DB 2/390 8 as DB setting.

Anyone having a hint why this does not work anymore? Or a new possibility to remove the difference when comparing the Data Model and Dictionary?

Thanks in advance, Robert


  • nihitthakkar
    nihitthakkar Member Posts: 120 Blue Ribbon

    A BLOB (binary large object) is a varying-length binary string that can be up to 2,147,483,647 characters long. Like other binary types, BLOB strings are not associated with a code page. In addition, BLOB strings do not hold character data.

    The Physical Data Model of the Oracle Communications Data Model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, and Materialized Views have been added to aid performance.

    The Oracle data dictionary is one of the most important components of the Oracle DBMS. It contains all information about the structures and objects of the database such as. • tables, • columns, • users, • data files etc. The data stored in the data dictionary are also often called metadata.

Sign In or Register to comment.