{"action":"created","issue":{"url":"https://api.github.com/repos/phanan/koel/issues/323","repository_url":"https://api.github.com/repos/phanan/koel","labels_url":"https://api.github.com/repos/phanan/koel/issues/323/labels{/name}","comments_url":"https://api.github.com/repos/phanan/koel/issues/323/comments","events_url":"https://api.github.com/repos/phanan/koel/issues/323/events","html_url":"https://github.com/phanan/koel/issues/323","id":152874778,"number":323,"title":"Artist is too large","user":{"login":"fxthomas","id":613594,"avatar_url":"https://avatars.githubusercontent.com/u/613594?v=3","gravatar_id":"","url":"https://api.github.com/users/fxthomas","html_url":"https://github.com/fxthomas","followers_url":"https://api.github.com/users/fxthomas/followers","following_url":"https://api.github.com/users/fxthomas/following{/other_user}","gists_url":"https://api.github.com/users/fxthomas/gists{/gist_id}","starred_url":"https://api.github.com/users/fxthomas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxthomas/subscriptions","organizations_url":"https://api.github.com/users/fxthomas/orgs","repos_url":"https://api.github.com/users/fxthomas/repos","events_url":"https://api.github.com/users/fxthomas/events{/privacy}","received_events_url":"https://api.github.com/users/fxthomas/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-03T21:08:48Z","updated_at":"2016-05-04T22:02:43Z","closed_at":null,"body":"I've got some songs that don't fit inside the database, which makes `koel:sync` crash after a while with :\r\n\r\n```\r\n[Illuminate\\DatabaseQueryException]                                                                                                                                                       \r\n  SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(255) (SQL: insert into \"artists\" (\"name\", \"updated_at\", \"created_at\") values (&#23470;  \r\n  &#20869;&#12428;&#12435;&#12370;(&#23567;&#23721;&#20117;&#12371;&#12392;&#12426;)&#12289;&#19968;&#26465;&#34509;(&#26449;&#24029;&#26792;&#34915;)&#12289;&#36234;&#35895;&#22799;&#280  \r\n  23;(&#20304;&#20489;&#32190;&#38899;)&#12289;&#36234;&#35895;&#23567;&#38816;(&#38463;&#28548;&#20339;&#22856;), 2016-05-03 20:58:17, 2016-05-03 20:58:17) returning \"id\")\r\n```\r\n\r\nYeah, why the hell do I even have this on my library? :smile:\r\n\r\nI was hesitant in posting the issue since it probably won't happen very often, but this is real metadata fetched from MusicBrainz, so more or less public.\r\n\r\nI'm using PostgreSQL which AFAIK handles `varying(255)` roughly the same way as `text`, but I'm not sure about performance impacts for MySQL. For comparison, Beets uses `text` in its SQLite database and has no issue with this.\r\n\r\nKoel version is 2.2.0."},"comment":{"url":"https://api.github.com/repos/phanan/koel/issues/comments/217017499","html_url":"https://github.com/phanan/koel/issues/323#issuecomment-217017499","issue_url":"https://api.github.com/repos/phanan/koel/issues/323","id":217017499,"user":{"login":"fxthomas","id":613594,"avatar_url":"https://avatars.githubusercontent.com/u/613594?v=3","gravatar_id":"","url":"https://api.github.com/users/fxthomas","html_url":"https://github.com/fxthomas","followers_url":"https://api.github.com/users/fxthomas/followers","following_url":"https://api.github.com/users/fxthomas/following{/other_user}","gists_url":"https://api.github.com/users/fxthomas/gists{/gist_id}","starred_url":"https://api.github.com/users/fxthomas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxthomas/subscriptions","organizations_url":"https://api.github.com/users/fxthomas/orgs","repos_url":"https://api.github.com/users/fxthomas/repos","events_url":"https://api.github.com/users/fxthomas/events{/privacy}","received_events_url":"https://api.github.com/users/fxthomas/received_events","type":"User","site_admin":false},"created_at":"2016-05-04T22:02:43Z","updated_at":"2016-05-04T22:02:43Z","body":"Oh, fun. Koel is apparently storing Unicode characters as HTML entities in the database :\r\n\r\n```sql\r\nselect name from artists limit 1;\r\n-- &#27700;&#35895;&#24195;&#23455;\r\n```\r\n\r\nIs that the expected behavior or does that happen because I'm using PostgreSQL instead of MySQL?"}}