Dans la fen\u00eatre “Source Database”, activer le bouton “Advanced” et compl\u00e9ter le champ “Connection string” avec :
\njdbc:jtds:sqlserver:\/\/server:1433\/database;user=user;password=password;useUnicode=true;domain=<\/p>\n
Dans la fen\u00eatre “Target Database”, activer le bouton “Advanced” et compl\u00e9ter le champ “Connection string” avec :
\njdbc:mysql:\/\/server:3306\/?user=user&password=password&useServerPrepStmts=false&useUnicode=true<\/p>\n
,en rempla\u00e7ant bien sur “server” et “database” par leurs valeurs respectives.<\/p>\n
Ensuite, ne pas modifier les options qui permettent de changer l’encodage des caract\u00e8res : les valeurs par d\u00e9faut font l’affaire. Et voil\u00e0 !<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"
Mysql Migration Toolkit has an issue with varchar different from varchar(255) : it considers that it is not useful to force utf8 for these fields ! Here is a solution, found here : Dans la fen\u00eatre “Source Database”, activer le … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-486","post","type-post","status-publish","format-standard","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/comments?post=486"}],"version-history":[{"count":1,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts\/486\/revisions"}],"predecessor-version":[{"id":487,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/posts\/486\/revisions\/487"}],"wp:attachment":[{"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/media?parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/categories?post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dotmana.com\/weblog\/wp-json\/wp\/v2\/tags?post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}