Nvarchar- sql server to Varchar - mysq
Posted by: Kevin Evans
Date: November 04, 2013 03:54PM

I have been trying to use the migration toolkit in mysql workbench V6 to generate a schema from my sql server database. I am finding that for columns defined as nvarchar in sql server the toolkit generates a varchar column of twice the length in mysql even though the corresponding mysql column is utf8.

e.g a sqlserver NVARCHAR(255) is generating a VARCHAR(510) column in mysql. As the mysql column is utf8 this should only have a length of 255 matching the sqlserver column.

Please can you clarify whether my understanding is correct and that the column lengths generated are incorrect or provide an explanation for this?

Thanks

Kevin

Options: ReplyQuote


Subject
Written By
Posted
Nvarchar- sql server to Varchar - mysq
November 04, 2013 03:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.