View Single Post

   
  #1 (permalink)  
Old 04-19-2008, 07:38 PM
Dirk Moolman
 
Posts: n/a
Default VARCHAR or not ?



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 ?


Regards
Dirk



sending to informix-list
Reply With Quote