mssql2mysql
mssql2mysql copied to clipboard
There seems to be a max size set for query results?
Hi @matriphe
I am getting an issue where large data fields are cut off to 65535 bytes.
That is because:
A BLOB type in MySQL can store up to 65,534 bytes
MEDIUMBLOB can store up to 16,777,213 bytes
LONGBLOB can store up to 4,294,967,292 bytes
So we should check the size of biggest for a specific field and change accordingly.
I think we should also look at strict mode so users know when there is a potential error.
We need to do the same thing with TEXT
, MEDIUMTEXT
, LARGETEXT