MySQL handles nchar differently than MSSQL

[acnicholls]

in MySQL [nchar] is also "[char] COLLATE utf8", so in order to handle changing it correctly when creating a MSSQL script, we must add logic to determine if utf8 is being used, then convert to [nchar]

Same for [varchar] and [nvarchar]

when testing for the data type, one must look at both the columns data type and collation data.

SIDENOTE: MySQL defaults to utf8, so all [char] fields are by default [nchar]