There seems to be a max size set for query results?

matriphe / mssql2mysql

Simple MS SQL to MySQL PHP script converter

30 stars 25 forks source link

There seems to be a max size set for query results? #5

Open surfer190 opened 9 years ago

surfer190 commented 9 years ago

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.

surfer190 commented 9 years ago

We need to do the same thing with TEXT, MEDIUMTEXT, LARGETEXT