Dirk Moolman wrote:

> Solaris 8
> IDS 7.31 FD3
>
>
> We have to create a table, that will contain a code, a short description
> and then a long description (up to 2000 characters). This is basically a
> lookup table, and will be used for browsing, verifying and selecting
> codes.
>
> Varchar has a limit of 255 characters. Does this mean I have to define a
> char(2000) column for the long description ?
>
> Any suggestions ?

Upgrade to 9.30 or 9.40 -- use the LVARCHAR data type, which can now be (I
think) up to 32K. Definitely 2K.