topic Use 'text' instead of 'varchar' in PostgreSQL 9.x in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/use-text-instead-of-varchar-in-postgresql-9-x/m-p/238861#M191991 <HTML><HEAD></HEAD><BODY><SPAN>According to PostgreSQL mail developers, you can exchange all "varchar(…)" by text with advantages only (if should work even faster, because PostgreSQL doesn't need to enforce size).</SPAN><BR /><BR /><SPAN>Reference: </SPAN><A href="https://www.postgresql.org/docs/9.1/static/datatype-character.html" rel="nofollow noopener noreferrer">https://www.postgresql.org/docs/9.1/static/datatype-character.html</A><BR /><BR /><BLOCKQUOTE class="jive-quote">Tip: There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column. While character(n) has performance advantages in some other database systems, there is no such advantage in PostgreSQL; in fact character(n) is usually the slowest of the three because of its additional storage costs. In most situations text or character varying should be used instead.</BLOCKQUOTE><BR /><SPAN>I'm running Activiti 5.20.0 with "text" instead "varchar", and have found no error so far.</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Edson Richter</SPAN></BODY></HTML> Sat, 04 Jun 2016 20:56:54 GMT edsonrichter 2016-06-04T20:56:54Z Use 'text' instead of 'varchar' in PostgreSQL 9.x https://connect.hyland.com/t5/alfresco-archive/use-text-instead-of-varchar-in-postgresql-9-x/m-p/238861#M191991 According to PostgreSQL mail developers, you can exchange all "varchar(…)" by text with advantages only (if should work even faster, because PostgreSQL doesn't need to enforce size).Reference: https://www.postgresql.org/docs/9.1/static/datatype-character.htmlTip: There is no performance difference a Sat, 04 Jun 2016 20:56:54 GMT https://connect.hyland.com/t5/alfresco-archive/use-text-instead-of-varchar-in-postgresql-9-x/m-p/238861#M191991 edsonrichter 2016-06-04T20:56:54Z Re: Use 'text' instead of 'varchar' in PostgreSQL 9.x https://connect.hyland.com/t5/alfresco-archive/use-text-instead-of-varchar-in-postgresql-9-x/m-p/238862#M191992 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Edson,</SPAN><BR /><SPAN>As I read in the link you provided It seems it is a good idea to change it, but before changing it we should make sure there are no other side effects in the context of this application.</SPAN><BR /><BR /><SPAN>Thanks for the hint.</SPAN></BODY></HTML> Mon, 06 Jun 2016 06:04:27 GMT https://connect.hyland.com/t5/alfresco-archive/use-text-instead-of-varchar-in-postgresql-9-x/m-p/238862#M191992 vasile_dirla 2016-06-06T06:04:27Z