Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I am trying to convert a SQL Server database with a SQL_Latin1_General_CP1_CI_AS collation into a MySQL database using MySQL Workbench. I can successfully complete the process without any issues being thrown, but the target converted MySQL database won`t display any special characters like á, é, ç, ê and others. Actually, when there is a special character on the source SQL Server database, the rest of the column, from the point the special character appears, will be truncated. The issue I have is more or less the same as described here: How to convert control characters in MySQL from latin1 to UTF-8?.

The post above helped me. By switching the target MySQL database from UTF-8 to latin1 (latin1_general_ci) or cp1250 (cp1250_general_ci) I was able to do a better import job: special characters were not preserved, they would appear as question marks (?), but there was an improvement: the columns wouldn't get truncated anymore. In order to import data with the new collation, I had to manually edit the query in MySQL Workbench prior to importing. But after trying several different combinations, I am running out of options...

Any help is appreciated.

share|improve this question

closed as off-topic by Max Vernon, Paul White, bluefeet, Kin, dezso Oct 5 at 14:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, bluefeet, Kin, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.