{"action":"created","issue":{"url":"https://api.github.com/repos/rails/rails/issues/14579","labels_url":"https://api.github.com/repos/rails/rails/issues/14579/labels{/name}","comments_url":"https://api.github.com/repos/rails/rails/issues/14579/comments","events_url":"https://api.github.com/repos/rails/rails/issues/14579/events","html_url":"https://github.com/rails/rails/pull/14579","id":30772944,"number":14579,"title":"PostgreSQL, remove varchar limit.","user":{"login":"senny","id":5402,"avatar_url":"https://avatars.githubusercontent.com/u/5402?v=3","gravatar_id":"","url":"https://api.github.com/users/senny","html_url":"https://github.com/senny","followers_url":"https://api.github.com/users/senny/followers","following_url":"https://api.github.com/users/senny/following{/other_user}","gists_url":"https://api.github.com/users/senny/gists{/gist_id}","starred_url":"https://api.github.com/users/senny/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/senny/subscriptions","organizations_url":"https://api.github.com/users/senny/orgs","repos_url":"https://api.github.com/users/senny/repos","events_url":"https://api.github.com/users/senny/events{/privacy}","received_events_url":"https://api.github.com/users/senny/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rails/rails/labels/activerecord","name":"activerecord","color":"0b02e1"},{"url":"https://api.github.com/repos/rails/rails/labels/PostgreSQL","name":"PostgreSQL","color":"fbca04"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":14,"created_at":"2014-04-03T13:02:54Z","updated_at":"2015-06-12T07:38:33Z","closed_at":"2014-04-04T22:52:39Z","pull_request":{"url":"https://api.github.com/repos/rails/rails/pulls/14579","html_url":"https://github.com/rails/rails/pull/14579","diff_url":"https://github.com/rails/rails/pull/14579.diff","patch_url":"https://github.com/rails/rails/pull/14579.patch"},"body":"Closes #13435\r\nCloses #9153\r\n\r\nThere is no reason for the PG adapter to have a default limit of 255 on :string\r\ncolumns. See this snippet from the PG docs:\r\n\r\n    Tip: There is no performance difference among these three types, apart\r\n    from increased storage space when using the blank-padded type, and a\r\n    few extra CPU cycles to check the length when storing into a\r\n    length-constrained column. While character(n) has performance\r\n    advantages in some other database systems, there is no such advantage\r\n    in PostgreSQL; in fact character(n) is usually the slowest of the\r\n    three because of its additional storage costs. In most situations text\r\n    or character varying should be used instead."},"comment":{"url":"https://api.github.com/repos/rails/rails/issues/comments/111394787","html_url":"https://github.com/rails/rails/pull/14579#issuecomment-111394787","issue_url":"https://api.github.com/repos/rails/rails/issues/14579","id":111394787,"user":{"login":"Envek","id":264400,"avatar_url":"https://avatars.githubusercontent.com/u/264400?v=3","gravatar_id":"","url":"https://api.github.com/users/Envek","html_url":"https://github.com/Envek","followers_url":"https://api.github.com/users/Envek/followers","following_url":"https://api.github.com/users/Envek/following{/other_user}","gists_url":"https://api.github.com/users/Envek/gists{/gist_id}","starred_url":"https://api.github.com/users/Envek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Envek/subscriptions","organizations_url":"https://api.github.com/users/Envek/orgs","repos_url":"https://api.github.com/users/Envek/repos","events_url":"https://api.github.com/users/Envek/events{/privacy}","received_events_url":"https://api.github.com/users/Envek/received_events","type":"User","site_admin":false},"created_at":"2015-06-12T07:38:33Z","updated_at":"2015-06-12T07:38:33Z","body":"@fphilipe It's kind of convention to use `character varying` columns for single line values and `text` for multiline. For example libraries like [simple_form] are rendering `input` tags for `character varying` type attributes and `textarea` tags for `text` type values. It's quite convenient.\r\n\r\n[simple_form]: https://github.com/plataformatec/simple_form"}}