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. I'm not reverse engineering them from the schema for a couple of reasons.

Thanx,
Garth

Reply via email to