{"action":"opened","issue":{"url":"https://api.github.com/repos/Araq/Nim/issues/2261","labels_url":"https://api.github.com/repos/Araq/Nim/issues/2261/labels{/name}","comments_url":"https://api.github.com/repos/Araq/Nim/issues/2261/comments","events_url":"https://api.github.com/repos/Araq/Nim/issues/2261/events","html_url":"https://github.com/Araq/Nim/issues/2261","id":59750733,"number":2261,"title":"Character set in db_mysql","user":{"login":"kemege","id":4485522,"avatar_url":"https://avatars.githubusercontent.com/u/4485522?v=3","gravatar_id":"","url":"https://api.github.com/users/kemege","html_url":"https://github.com/kemege","followers_url":"https://api.github.com/users/kemege/followers","following_url":"https://api.github.com/users/kemege/following{/other_user}","gists_url":"https://api.github.com/users/kemege/gists{/gist_id}","starred_url":"https://api.github.com/users/kemege/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kemege/subscriptions","organizations_url":"https://api.github.com/users/kemege/orgs","repos_url":"https://api.github.com/users/kemege/repos","events_url":"https://api.github.com/users/kemege/events{/privacy}","received_events_url":"https://api.github.com/users/kemege/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-03-04T05:04:01Z","updated_at":"2015-03-04T05:04:01Z","closed_at":null,"body":"Procedures in the `db_mysql` library don't seem to involve anything about character sets.\r\n\r\nWhen I use `db_mysql.open` on my computer, the default character set is `latin1`, so I cannot work with unicode characters unless I call `mysql.set_character_set`. (I'm using Windows 7 and the libmysql.dll is shipped with pyQt5. Although it's version is not the same as the MySQL server, I don't think it has anything to do with the character set.)\r\n\r\nAs UTF-8 is the most used encoding in Nim, maybe we can add `mysql.set_character_set` into `db_mysql.open` to change the character set to UTF-8 after opening a connection, or provide a procedure in `db_mysql` which calls `mysql.set_character_set`?"}}