dbptk-ui icon indicating copy to clipboard operation
dbptk-ui copied to clipboard

Published 20 hours ago • verified publisher icon keeps

DBPTK desktop does not report error - SIARD to MySQL

Open MartinR4838 opened this issue 4 years ago • 1 comments

Description:

DBPTK desktop does not report error when migrating SIARD to MySQL. SIARD was created from SQL Server. Error is caused by datatype Varchar (8000) which can´t be migrated to MySQL. When using DBPTK in command line error is reported.

Kind regards

MartinR4838 avatar Jul 21 '20 11:07 MartinR4838

MySQL row size limit is for Varchar(65,535 Bytes) which means (21,844) for utf8. SIARD import can fail when table rows in original DB exceed this limit. In our case original table has 41 columns and 3 from them have original data type Varchar(8000)

MartinR4838 avatar Jul 24 '20 06:07 MartinR4838