Forum Stats

  • 3,782,250 Users
  • 2,254,623 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