Proposal: Entity Engine Field Type Improvement

[Adrian Crum-3]

URLs can be an arbitrary length. The common advice is to limit their
length to 2000 characters to avoid problems with some browsers.

I propose that we change the "url" field type to allow 2000 characters:

<field-type-def type="url" sql-type="VARCHAR(2000)" java-type="String"/>

This should not be an SQL CLOB because some databases will not allow
comparisons or indexing on CLOB fields.

What do you think?

--
Adrian Crum
Sandglass Software
www.sandglass-software.com

[Jacques Le Roux]

This sounds wise to me

Jacques

Adrian Crum wrote:

> URLs can be an arbitrary length. The common advice is to limit their
> length to 2000 characters to avoid problems with some browsers.
>
> I propose that we change the "url" field type to allow 2000 characters:
>
> <field-type-def type="url" sql-type="VARCHAR(2000)" java-type="String"/>
>
> This should not be an SQL CLOB because some databases will not allow
> comparisons or indexing on CLOB fields.
>
> What do you think?