Subject Using domains with VARCHAR
Author akahanek@qgir.cz
>From: Geoff Worboys [mailto:geoff@...]
>
>Sorry, I sort of assumed that most people use domains because they
>simplify and clarify SQL code (and client definitions using the
>configuration described above).

Geoff,
I used domains for most of fields in my DB. Then an issue appeared:
There was domain NAME_DM VARCHAR(30) and a lot of fields based on this
domain in DB. Then my customer wanted to extend one field size from 30
to 40 chars. So to accomplish the consistency between domain definition
and the real fields size I changed the domain definition and then _all_
fields definition. (Changing the domain definition does not really
affect the existing field size).

If I did not use domains in such case, I could change only the one
requested field. Was there any better solution?