Cayenne DbAttribute types are all taken from JDBC spec. Nominally PG 'text'
maps to JDBC 'CLOB', and 'varchar(n)' to VARCHAR. However PG promises no
performance differences between 'text' and 'varchar(n)'. So certainly you can
map 'text' as either.
On the other hand, (and this was on MySQL, not
I'm converting from MS SQL Server to PostgreSQL, switching from VARCHAR
in SQL Server to TEXT (or CITEXT depending) in PG. I'm converting the
software from MS AccessVB to Java/Cayenne and am wondering if there is a
preference for CLOB over VARCHAR(n) when hand generating the DBEntity
attributes
