Re: VARCHAR vs LONGVARCHAR vs CLOB
Andrus Adamchik <[email protected]>
| Newsgroups | gmane.comp.java.cayenne.user |
|---|---|
| Message-ID | <[email protected]> |
> should I just define everything as VARCHAR and forget about it? Yes. CLOBs have some special handling, which is irrelevant for Postgres. > On Sep 7, 2020, at 5:43 PM, Hugi Thordarson <[email protected]> wrote: > > Hi all, > while looking further into migration to 4.2 I noticed my model has several DbAttributes defined as CLOBs, leftovers from our previous database (Informix). > > Since we have migrated to Postgres and these columns are now just regular varchar/text columns, I'm going to redefine them in the model as such. So I'm wondering, mainly out of curiosity; is there any difference in how fields of type VARCHAR and LONGVARCHAR are handled WRT Cayenne or should I just define everything as VARCHAR and forget about it? > > Cheers, > - hugi