{"action":"reopened","issue":{"url":"https://api.github.com/repos/go-sql-driver/mysql/issues/405","repository_url":"https://api.github.com/repos/go-sql-driver/mysql","labels_url":"https://api.github.com/repos/go-sql-driver/mysql/issues/405/labels{/name}","comments_url":"https://api.github.com/repos/go-sql-driver/mysql/issues/405/comments","events_url":"https://api.github.com/repos/go-sql-driver/mysql/issues/405/events","html_url":"https://github.com/go-sql-driver/mysql/issues/405","id":126897850,"number":405,"title":"time_zone DSN parameter value requires quoting","user":{"login":"dolmen","id":129536,"avatar_url":"https://avatars.githubusercontent.com/u/129536?v=3","gravatar_id":"","url":"https://api.github.com/users/dolmen","html_url":"https://github.com/dolmen","followers_url":"https://api.github.com/users/dolmen/followers","following_url":"https://api.github.com/users/dolmen/following{/other_user}","gists_url":"https://api.github.com/users/dolmen/gists{/gist_id}","starred_url":"https://api.github.com/users/dolmen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dolmen/subscriptions","organizations_url":"https://api.github.com/users/dolmen/orgs","repos_url":"https://api.github.com/users/dolmen/repos","events_url":"https://api.github.com/users/dolmen/events{/privacy}","received_events_url":"https://api.github.com/users/dolmen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/go-sql-driver/mysql/labels/documentation","name":"documentation","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/go-sql-driver/mysql/milestones/7","html_url":"https://github.com/go-sql-driver/mysql/milestones/v1.3","labels_url":"https://api.github.com/repos/go-sql-driver/mysql/milestones/7/labels","id":616976,"number":7,"title":"v1.3","description":"","creator":{"login":"julienschmidt","id":944947,"avatar_url":"https://avatars.githubusercontent.com/u/944947?v=3","gravatar_id":"","url":"https://api.github.com/users/julienschmidt","html_url":"https://github.com/julienschmidt","followers_url":"https://api.github.com/users/julienschmidt/followers","following_url":"https://api.github.com/users/julienschmidt/following{/other_user}","gists_url":"https://api.github.com/users/julienschmidt/gists{/gist_id}","starred_url":"https://api.github.com/users/julienschmidt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julienschmidt/subscriptions","organizations_url":"https://api.github.com/users/julienschmidt/orgs","repos_url":"https://api.github.com/users/julienschmidt/repos","events_url":"https://api.github.com/users/julienschmidt/events{/privacy}","received_events_url":"https://api.github.com/users/julienschmidt/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":56,"state":"open","created_at":"2014-04-01T16:31:08Z","updated_at":"2016-10-25T16:45:26Z","due_on":"2016-11-30T00:00:00Z","closed_at":null},"comments":1,"created_at":"2016-01-15T15:44:01Z","updated_at":"2016-10-25T16:45:26Z","closed_at":null,"body":"To set the `time_zone` from the DSN, the value must be quoted. But **this is not correctly [documented](../#system-variables)**.\r\n\r\nExamples (named time zone really work only [if the time_zone tables exists on the server](https://dev.mysql.com/doc/refman/5.6/en/mysql-tzinfo-to-sql.html)):\r\n\r\n| Wanted value  | Fails | Works |\r\n|---|---|---|\r\n| `+00:00` | `&time_zone=%2B00%3A00` | `&time_zone=%27%2B00%3A00%27`  |\r\n| `UTC` | `&time_zone=UTC` | `&time_zone=%27UTC%27` |\r\n| `Europe/Paris`  | `&time_zone=Europe%2FParis`  | `&time_zone=%27Europe%2FParis%27`  |\r\n\r\nI suppose the same issue will happen for any session parameter that is of type string.\r\n\r\nI find that using quoting in counter-intuitive, so I'm not sure if this is that the documentation that should be fixed."}}
{"actor":{"display_login":"julienschmidt"}}