You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
According to SQLAlchemy issue #3883, the LargeBinary type in SQLAlchemy should correspond to the BLOB type in MySQL. However, even though my ORM column is defined as LargeBinary and the actual database column type is BLOB, Alembic is still detecting this as a type change during migration. Why is this happening when these types should be considered equivalent?
And where is LONGBLOB comes, as the column type in MySQL is blob.
2025-07-21 13:28:59.973 - alembic.autogenerate.compare:(compare.py:1016) - INFO - Detected type change from LONGBLOB() to LargeBinary(length=4294967295) on 'xxxx'
2025-07-21 13:28:59.977 - alembic.autogenerate.compare:(compare.py:1016) - INFO - Detected type change from LONGBLOB() to LargeBinary(length=4294967295) on 'xxxx'
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
According to SQLAlchemy issue #3883, the LargeBinary type in SQLAlchemy should correspond to the BLOB type in MySQL. However, even though my ORM column is defined as LargeBinary and the actual database column type is BLOB, Alembic is still detecting this as a type change during migration. Why is this happening when these types should be considered equivalent?
And where is
LONGBLOB
comes, as the column type in MySQL isblob
.Beta Was this translation helpful? Give feedback.
All reactions