How can I define an Upper Case Field in EDB2?

DBISAM:
.... "ID" CHARACTER(3) NOT NULL CHARCASE UPPER, ...

The data should be saved as uppercase in the database.

Regards
Rolf

I don't think there is an equivalent definition in EDB. EDB is using
collations and while you can specify column as case insensitive for
comparisons it won't help converting the data into uppercase.

My suggestion would be an insert/update trigger that does the UPPER
function on the column.

Or if you're adding data thru app then uppercase it before insert
(trigger would be more universal though).

Raul

On 7/10/2012 12:47 PM, Rolf Frei [Team Elevate] wrote:
> How can I define an Upper Case Field in EDB2?
>
> DBISAM:
> ... "ID" CHARACTER(3) NOT NULL CHARCASE UPPER, ...
>
> The data should be saved as uppercase in the database.
>
> Regards
> Rolf