topic Re: Use 'text' instead of 'varchar' in PostgreSQL 9.x in Alfresco Archive

Use 'text' instead of 'varchar' in PostgreSQL 9.x

edsonrichter — Sat, 04 Jun 2016 20:56:54 GMT

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

Re: Use 'text' instead of 'varchar' in PostgreSQL 9.x

vasile_dirla — Mon, 06 Jun 2016 06:04:27 GMT

Thanks Edson,
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.

Thanks for the hint.