The Grails automatically identifies what should be the datatype of the field in sql table e.g; fields with String datatype are converted to varchar(255), but sometimes we need to store the data more than 255 characters. In such cases earlier I used to alter the table in the database. But now I found the better solution for this problem. Again a simple configuration in the domain class can do the trick for you. In static mapping of domain class you just need to assign the type to that particular field. If you want to store the huge data you can assign “text” to it<\/p>\n
\r\nclass Event {\r\n String title;\r\n Date date;\r\n \r\n static mapping = {\r\n title type:\"text\"\r\n }\r\n}\r\n<\/pre>\nIf this doesn’t look a right solution to you and you want specific length to the data as we can do in database you can do that here as well<\/p>\n
\r\n static mapping = {\r\n title column: \"title\", sqlType: \"varchar(5000)\"\r\n }\r\n<\/pre>\nThis is really so easy, its just I never looked for the right solution
\n<\/p>\n
Hope it helps
\nUday Pratap Singh<\/a>
\nuday@intelligrape.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"The Grails automatically identifies what should be the datatype of the field in sql table e.g; fields with String datatype are converted to varchar(255), but sometimes we need to store the data more than 255 characters. In such cases earlier I used to alter the table in the database. But now I found the better […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":15,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-834","post","type-post","status-publish","format-standard","hentry","category-grails"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t