sql server migration assistant - mapping varchar to varchar

Cesar Tomita 20 Reputation points
2023-12-28T12:39:38.2466667+00:00

Hi!

I am using SQL Server Migration Assistant for MySQL to migrate a database to SQL Server. However, trying to map the varchar type to varchar only leaves me with the nvarchar type? How do I adjust this?

mysqltosql

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
0 comments
Accepted answer
  1. Olaf Helper 42,841 Reputation points
    2023-12-28T13:06:32.73+00:00

    However, trying to map the varchar type to varchar only leaves me with the nvarchar type? How do I adjust this?

    And that's fully correct, MySQL has only the data type "varchar" where you can additional charactersets and collation, see

    See https://dev.mysql.com/doc/refman/8.0/en/string-types.html

    So "MySQL varchar" = "MS SQL nvarchar"

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cesar Tomita 20 Reputation points
    2023-12-28T13:38:30.7633333+00:00

    Hmm, I understand.

    So the 'equivalent' of nvarchar in sql server, is the 'varchar standard' in MySQL?

    To perform the conversion from varchar to varchar, would it only be via t-sql?

    0 comments