topic Re: deciding on the varchar strategy in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/deciding-on-the-varchar-strategy/m-p/40810#M21839 <HTML><HEAD></HEAD><BODY><SPAN>I think the default for many (most?) platforms is VARCHAR(1) which probably isn't what we want. Also not all platforms always have the "VARCHAR" alias, but that's another story (we need platform specific scripts). So we should choose an appropriate value for all the columns, and expect that users may want to tweak them in production.</SPAN></BODY></HTML> Mon, 26 Jul 2010 02:39:19 GMT dsyer 2010-07-26T02:39:19Z deciding on the varchar strategy https://connect.hyland.com/t5/alfresco-archive/deciding-on-the-varchar-strategy/m-p/40809#M21838 some text columns have varchar(255), some just varchar.i think the motivation to have (255) is that some dbs handle fixed length strings much more efficient then open ended varchars.&nbsp; maybe it's less portable.we should list all arguments, decide and document the strategy.who's got thoughts on this? Sat, 24 Jul 2010 08:08:53 GMT https://connect.hyland.com/t5/alfresco-archive/deciding-on-the-varchar-strategy/m-p/40809#M21838 tombaeyens 2010-07-24T08:08:53Z Re: deciding on the varchar strategy https://connect.hyland.com/t5/alfresco-archive/deciding-on-the-varchar-strategy/m-p/40810#M21839 <HTML><HEAD></HEAD><BODY><SPAN>I think the default for many (most?) platforms is VARCHAR(1) which probably isn't what we want. Also not all platforms always have the "VARCHAR" alias, but that's another story (we need platform specific scripts). So we should choose an appropriate value for all the columns, and expect that users may want to tweak them in production.</SPAN></BODY></HTML> Mon, 26 Jul 2010 02:39:19 GMT https://connect.hyland.com/t5/alfresco-archive/deciding-on-the-varchar-strategy/m-p/40810#M21839 dsyer 2010-07-26T02:39:19Z