MSSQL Migration fails

I used dirty Joe’s hex editor to add VARCHAR(50) and the migration was then a success. I guess I could have forked the open source project, and used maven to rebuild it with my changes.

I clicked next through the DB install. I did set the collation on the DB to SQL_Latin1_General_CP1250_CS_AS, thinking that perhaps the system tables had something to do with the failed migration. I had restored 5.6.6 the DB to several different instances, and all of them had the same issue.

en_sql_server_2016_developer_x64_dvd_8777069.iso

I don’t know how I would change the default length of built in type, but I try not to depend on defaults. I’m betting the default is 30, and that’s why it’s cutting off the S.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/char-and-varchar-transact-sql?view=sql-server-2017