[BioSQL-l] value field in seqfeature_qualifier_value too small

[David Scott]

in seqfeature_qualifier_value:
 
  SEQFEATURE_ID                             NOT NULL NUMBER(38)
  TERM_ID                                   NOT NULL NUMBER(38)
  RANK                                      NOT NULL NUMBER(3)
  VALUE                                              VARCHAR2(4000)
 
 the value field is restricted to 4000 bytes - 4000 bytes too small to 
 carry current genbank protein translations - e.g. AB016240.1 has a 
 protein translation of 4133 characters. since 4000 bytes is a string 
 length restriction for some jdbc drivers - to increase the field size, 
 the field type should also be changed to clob.