{"action":"closed","issue":{"url":"https://api.github.com/repos/drush-ops/drush/issues/1212","labels_url":"https://api.github.com/repos/drush-ops/drush/issues/1212/labels{/name}","comments_url":"https://api.github.com/repos/drush-ops/drush/issues/1212/comments","events_url":"https://api.github.com/repos/drush-ops/drush/issues/1212/events","html_url":"https://github.com/drush-ops/drush/issues/1212","id":59252481,"number":1212,"title":"Problem with special characters in SQLSRV driver","user":{"login":"david-garcia-garcia","id":9599352,"avatar_url":"https://avatars.githubusercontent.com/u/9599352?v=3","gravatar_id":"","url":"https://api.github.com/users/david-garcia-garcia","html_url":"https://github.com/david-garcia-garcia","followers_url":"https://api.github.com/users/david-garcia-garcia/followers","following_url":"https://api.github.com/users/david-garcia-garcia/following{/other_user}","gists_url":"https://api.github.com/users/david-garcia-garcia/gists{/gist_id}","starred_url":"https://api.github.com/users/david-garcia-garcia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/david-garcia-garcia/subscriptions","organizations_url":"https://api.github.com/users/david-garcia-garcia/orgs","repos_url":"https://api.github.com/users/david-garcia-garcia/repos","events_url":"https://api.github.com/users/david-garcia-garcia/events{/privacy}","received_events_url":"https://api.github.com/users/david-garcia-garcia/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-27T15:42:56Z","updated_at":"2015-05-09T20:34:12Z","closed_at":"2015-05-09T20:34:12Z","body":"In SQL\\SQLsqlsrv.php when creating the command line based sentence to open database connection, if any of the parameters (username or password) have special characters in them (such as an ampersand) the command will fail.\r\n\r\nWe can either escape special characters (with ^) or close them inside quotes.\r\n\r\nreturn ' -S ' . $host . ' -d ' . $database . ' -U ' . $this->db_spec['username'] . ' -P ' . '\"' . $this->db_spec['password'] . '\"';"}}