{"action":"created","issue":{"url":"https://api.github.com/repos/opencats/OpenCATS/issues/44","repository_url":"https://api.github.com/repos/opencats/OpenCATS","labels_url":"https://api.github.com/repos/opencats/OpenCATS/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/opencats/OpenCATS/issues/44/comments","events_url":"https://api.github.com/repos/opencats/OpenCATS/issues/44/events","html_url":"https://github.com/opencats/OpenCATS/issues/44","id":102920589,"number":44,"title":"Configuration of DB connection encoding","user":{"login":"pes-soft","id":13953259,"avatar_url":"https://avatars.githubusercontent.com/u/13953259?v=3","gravatar_id":"","url":"https://api.github.com/users/pes-soft","html_url":"https://github.com/pes-soft","followers_url":"https://api.github.com/users/pes-soft/followers","following_url":"https://api.github.com/users/pes-soft/following{/other_user}","gists_url":"https://api.github.com/users/pes-soft/gists{/gist_id}","starred_url":"https://api.github.com/users/pes-soft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pes-soft/subscriptions","organizations_url":"https://api.github.com/users/pes-soft/orgs","repos_url":"https://api.github.com/users/pes-soft/repos","events_url":"https://api.github.com/users/pes-soft/events{/privacy}","received_events_url":"https://api.github.com/users/pes-soft/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/opencats/OpenCATS/milestones/3","html_url":"https://github.com/opencats/OpenCATS/milestones/Future","labels_url":"https://api.github.com/repos/opencats/OpenCATS/milestones/3/labels","id":1290480,"number":3,"title":"Future","description":null,"creator":{"login":"RussH","id":282748,"avatar_url":"https://avatars.githubusercontent.com/u/282748?v=3","gravatar_id":"","url":"https://api.github.com/users/RussH","html_url":"https://github.com/RussH","followers_url":"https://api.github.com/users/RussH/followers","following_url":"https://api.github.com/users/RussH/following{/other_user}","gists_url":"https://api.github.com/users/RussH/gists{/gist_id}","starred_url":"https://api.github.com/users/RussH/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RussH/subscriptions","organizations_url":"https://api.github.com/users/RussH/orgs","repos_url":"https://api.github.com/users/RussH/repos","events_url":"https://api.github.com/users/RussH/events{/privacy}","received_events_url":"https://api.github.com/users/RussH/received_events","type":"User","site_admin":false},"open_issues":11,"closed_issues":1,"state":"open","created_at":"2015-09-04T14:10:12Z","updated_at":"2016-03-02T12:18:14Z","due_on":null,"closed_at":null},"comments":10,"created_at":"2015-08-25T00:33:08Z","updated_at":"2016-07-13T21:36:04Z","closed_at":null,"body":"By default, new database connections via `mysql_connect` use *latin1* character encoding ( based on MySQL configuration ). This configuration works for standard functionality of OpenCATS, but it can degrade user experience in certain circumstances related to database ( i.e. search functionality, direct extraction of data from database by third party applications ).\r\n\r\nFor example this influences search of contacts, companies and other subjects which include special characters ( like á ) in the names. When DB connection is identical to database ( UTF-8 ), users can search for names with special characters without need to exactly specify the name ( for example *Libéreau* can be searched by *libereau* ).\r\n\r\nConfiguration of DB connection encoding could be provided in *config.php* and applied by `mysql_set_charset`, when connection is being established."},"comment":{"url":"https://api.github.com/repos/opencats/OpenCATS/issues/comments/232494183","html_url":"https://github.com/opencats/OpenCATS/issues/44#issuecomment-232494183","issue_url":"https://api.github.com/repos/opencats/OpenCATS/issues/44","id":232494183,"user":{"login":"pes-soft","id":13953259,"avatar_url":"https://avatars.githubusercontent.com/u/13953259?v=3","gravatar_id":"","url":"https://api.github.com/users/pes-soft","html_url":"https://github.com/pes-soft","followers_url":"https://api.github.com/users/pes-soft/followers","following_url":"https://api.github.com/users/pes-soft/following{/other_user}","gists_url":"https://api.github.com/users/pes-soft/gists{/gist_id}","starred_url":"https://api.github.com/users/pes-soft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pes-soft/subscriptions","organizations_url":"https://api.github.com/users/pes-soft/orgs","repos_url":"https://api.github.com/users/pes-soft/repos","events_url":"https://api.github.com/users/pes-soft/events{/privacy}","received_events_url":"https://api.github.com/users/pes-soft/received_events","type":"User","site_admin":false},"created_at":"2016-07-13T21:36:04Z","updated_at":"2016-07-13T21:36:04Z","body":"I think that using utf8mb4 with unicode collation for database is a good idea too.\r\n\r\nHow do you suggest to configure encoding for database connection? Should it be also forced to utf8mb4 ( at least for new installations ) or left for PHP to decide?"}}
{"actor":{"display_login":"pes-soft"}}