title: SQL Server Migration Assistant (SSMA): ERROR [22018] [MySQL][ODBC 5.3(a) Driver][mysqld-5.1.51-community]
body: <p>I am using SSMA for MySQL to migrate from MySQL to MSSQL and on several tables I am getting the 22018 error. After lots of mucking about I found that the error was being generated due to Russian characters being stored in these tables.</p>
  
  <p>For example: <code>Бухгалтерский учет</code></p>
  
  <p>There are other non-English characters in the tables, such as <code>Profissão Jurídica</code> and they are coming through OK.</p>
  
  <p>The error is to do with collation and the collation on the MySQL table is <code>latin1_swedish_ci</code> and the column that holds the "foreign" characters has <code>utf8_unicode_ci</code> collation on it and is a <code>varchar(255)</code>.</p>
  
  <p>The recipient table in MSSQL uses the database default collation (<code>Latin1_General_CI_AS</code>) and the recipient column is a <code>nvarchar(255)</code>.</p>
  
  <p>In SSMA the <em>charset mapping</em> for <code>latin1</code> is set to the default of <code>CHAR/VARCHAR</code> and I have tried having this set to <code>NCHAR/NVARCHAR</code> with no success. The <em>type mapping</em> for <code>varchar</code> is set to <code>nvarchar</code> for all instances.</p>
  
  <p>The only thing close to an answer that I have found is <a href="https://social.technet.microsoft.com/Forums/exchange/en-US/528e7363-fbba-4d0d-b2da-a326bf12e181/ssma-from-mysql-error-22018?forum=sqlservermigration" rel="noreferrer">this posting</a>. Unless I'm missing the point of the answer, I can't see that there is a missing conversion - or is there?</p>