Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Schema synchronization not working for data type integer length fields when blan

forums forums SQLyog SQLyog: Bugs / Feature Requests Schema synchronization not working for data type integer length fields when blan

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #36452
      Michael Flynn
      Participant

      I removed the “length” from the INT data types in my local table using phpStorm [they used to be INT(10) but now they are just INT].

      When I try to sync to my remote sever using the Schema Sync Tool the changes are shown but not made in the target table. They always default back to INT(11) so the tables are never in sync.

      Schema Sync Issue

      Please advise.

      SQLYog Ultimate 13.1.7 (64 bit)

    • #36459
      Michael Flynn
      Participant

      The interger datatype is deprecated in mySQL 8. How do I stop SQLyog from always applying it to my INT data types? My schema are never in sync because it seems SQLyog won’t accept a blank data length.

      https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html

      As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; you should expect support for it to be removed in a future version of MySQL.

    • #36460
      Michael Flynn
      Participant

      The integer datatype is deprecated in mySQL 8. How do I stop SQLyog from always applying it to my INT data types? My schema are never in sync because it seems SQLyog won’t accept a blank data length.

      https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html

      As of MySQL 8.0.17, the display width attribute is deprecated for integer data types; you should expect support for it to be removed in a future version of MySQL.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.