{"action":"created","issue":{"url":"https://api.github.com/repos/gtaylor44/SqlBulkTools/issues/19","repository_url":"https://api.github.com/repos/gtaylor44/SqlBulkTools","labels_url":"https://api.github.com/repos/gtaylor44/SqlBulkTools/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/gtaylor44/SqlBulkTools/issues/19/comments","events_url":"https://api.github.com/repos/gtaylor44/SqlBulkTools/issues/19/events","html_url":"https://github.com/gtaylor44/SqlBulkTools/issues/19","id":189075412,"number":19,"title":"Cannot resolve the collation conflict","user":{"login":"sbaxterg","id":17113697,"avatar_url":"https://avatars.githubusercontent.com/u/17113697?v=3","gravatar_id":"","url":"https://api.github.com/users/sbaxterg","html_url":"https://github.com/sbaxterg","followers_url":"https://api.github.com/users/sbaxterg/followers","following_url":"https://api.github.com/users/sbaxterg/following{/other_user}","gists_url":"https://api.github.com/users/sbaxterg/gists{/gist_id}","starred_url":"https://api.github.com/users/sbaxterg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbaxterg/subscriptions","organizations_url":"https://api.github.com/users/sbaxterg/orgs","repos_url":"https://api.github.com/users/sbaxterg/repos","events_url":"https://api.github.com/users/sbaxterg/events{/privacy}","received_events_url":"https://api.github.com/users/sbaxterg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-11-14T10:20:28Z","updated_at":"2016-11-16T13:45:54Z","closed_at":null,"body":"Hi,\r\n\r\nI'm having troubles to make an BulkInsertOrUpdate, I receive the error \"Cannot resolve the collation conflict between \"Latin1_General_CI_AS\" and \"SQL_Latin1_General_CP1_CI_AS\" in the equal to operation.\"\r\n\r\nThe server that runs the SQL Server has a default collation of \"Latin1_General_CI_AS\" but the database that I'm trying to update has a collation of \"SQL_Latin1_General_CP1_CI_AS\". It looks like the tool needs to set up the database collation in the generated sql to do the job right.\r\n\r\nIs possible to solve that?\r\n\r\nThanks.\r\n\r\nScott."},"comment":{"url":"https://api.github.com/repos/gtaylor44/SqlBulkTools/issues/comments/260949970","html_url":"https://github.com/gtaylor44/SqlBulkTools/issues/19#issuecomment-260949970","issue_url":"https://api.github.com/repos/gtaylor44/SqlBulkTools/issues/19","id":260949970,"user":{"login":"gtaylor44","id":11572604,"avatar_url":"https://avatars.githubusercontent.com/u/11572604?v=3","gravatar_id":"","url":"https://api.github.com/users/gtaylor44","html_url":"https://github.com/gtaylor44","followers_url":"https://api.github.com/users/gtaylor44/followers","following_url":"https://api.github.com/users/gtaylor44/following{/other_user}","gists_url":"https://api.github.com/users/gtaylor44/gists{/gist_id}","starred_url":"https://api.github.com/users/gtaylor44/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gtaylor44/subscriptions","organizations_url":"https://api.github.com/users/gtaylor44/orgs","repos_url":"https://api.github.com/users/gtaylor44/repos","events_url":"https://api.github.com/users/gtaylor44/events{/privacy}","received_events_url":"https://api.github.com/users/gtaylor44/received_events","type":"User","site_admin":false},"created_at":"2016-11-16T13:45:54Z","updated_at":"2016-11-16T13:45:54Z","body":"Wow thats one wide table. The challenge with setting it globally is type matching. Integers for example would throw an exception if you set a collation. Try setting a collation on the join (MatchTargetOn) columns."}}
{"actor":{"display_login":"gtaylor44"}}