{"action":"created","issue":{"url":"https://api.github.com/repos/jhipster/generator-jhipster/issues/1458","labels_url":"https://api.github.com/repos/jhipster/generator-jhipster/issues/1458/labels{/name}","comments_url":"https://api.github.com/repos/jhipster/generator-jhipster/issues/1458/comments","events_url":"https://api.github.com/repos/jhipster/generator-jhipster/issues/1458/events","html_url":"https://github.com/jhipster/generator-jhipster/issues/1458","id":74895343,"number":1458,"title":"use nvarchar for the entity generator Strings","user":{"login":"ryanhamilton","id":7273208,"avatar_url":"https://avatars.githubusercontent.com/u/7273208?v=3","gravatar_id":"","url":"https://api.github.com/users/ryanhamilton","html_url":"https://github.com/ryanhamilton","followers_url":"https://api.github.com/users/ryanhamilton/followers","following_url":"https://api.github.com/users/ryanhamilton/following{/other_user}","gists_url":"https://api.github.com/users/ryanhamilton/gists{/gist_id}","starred_url":"https://api.github.com/users/ryanhamilton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryanhamilton/subscriptions","organizations_url":"https://api.github.com/users/ryanhamilton/orgs","repos_url":"https://api.github.com/users/ryanhamilton/repos","events_url":"https://api.github.com/users/ryanhamilton/events{/privacy}","received_events_url":"https://api.github.com/users/ryanhamilton/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-05-10T11:06:37Z","updated_at":"2015-05-20T14:38:28Z","closed_at":null,"body":"Currently the entity generator asks for type, if string is specified it defaults to varchar(255). I suggest defaulting to nvarchar for strings. Yes it will take more space but it should reduce multi-language headaches later.\r\n\r\nI would also like to have been prompted for text size as I bumped into the default 255 limit without realizing.\r\n\r\nI think these suggestions would cause people the least surprises/problems later."},"comment":{"url":"https://api.github.com/repos/jhipster/generator-jhipster/issues/comments/103909008","html_url":"https://github.com/jhipster/generator-jhipster/issues/1458#issuecomment-103909008","issue_url":"https://api.github.com/repos/jhipster/generator-jhipster/issues/1458","id":103909008,"user":{"login":"jdubois","id":316835,"avatar_url":"https://avatars.githubusercontent.com/u/316835?v=3","gravatar_id":"","url":"https://api.github.com/users/jdubois","html_url":"https://github.com/jdubois","followers_url":"https://api.github.com/users/jdubois/followers","following_url":"https://api.github.com/users/jdubois/following{/other_user}","gists_url":"https://api.github.com/users/jdubois/gists{/gist_id}","starred_url":"https://api.github.com/users/jdubois/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdubois/subscriptions","organizations_url":"https://api.github.com/users/jdubois/orgs","repos_url":"https://api.github.com/users/jdubois/repos","events_url":"https://api.github.com/users/jdubois/events{/privacy}","received_events_url":"https://api.github.com/users/jdubois/received_events","type":"User","site_admin":false},"created_at":"2015-05-20T14:38:28Z","updated_at":"2015-05-20T14:38:28Z","body":"Is this only for MySQL? I don't have this problem with Postgresql (which is the database I use)\r\nI didn't see any issue on this yet, and we have people from all over the world, so I find this strange.\r\n\r\nFor the limit to 255, it's the default JPA size -> we always use the default for each technologies we use, because that's what we find is the less surprising.\r\nIf you select the \"validation\" question, then you can change this size, and it will be (obviously) validated."}}