You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Fredrik Liden <fl...@translate.com> on 2007/05/29 19:10:48 UTC

Mapping to Mysql TEXT type

If I want to use the Mysql TEXT datatype, how should I go about
specifying that in the modeler? Should I use "Other" and then manually
change it to TEXT in the database? Or should I use "Varchar" and set the
maximum string length to be something more in line with real TEXT
length?

Thanks!

Fredrik

Re: Mapping to Mysql TEXT type

Posted by Andrus Adamchik <an...@objectstyle.org>.

On May 29, 2007, at 8:10 PM, Fredrik Liden wrote:

> If I want to use the Mysql TEXT datatype, how should I go about
> specifying that in the modeler? Should I use "Other" and then manually
> change it to TEXT in the database? Or should I use "Varchar" and  
> set the
> maximum string length to be something more in line with real TEXT
> length?
>
> Thanks!
>
> Fredrik

Cayenne modeler DB types are the types from JDBC spec. So technically  
TEXT corresponds to CLOB. In practice I think both CLOB and VARCHAR  
should work.

Hope this helps.

Andrus