Hi, I am using sybase as my dat

[nickmc]

Hi,

I am using sybase as my database when hosting a dynamic web front end.

I can get the data to display on a browser but the data in my database is limited.
The structure of my database is as follows:

Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity
----------- ---- ----------- ----------- ----------- ----------- ------------ --------- -----------

GeneralDescription varchar 255 NULL NULL 1 NULL NULL 0

In looking at the datatypes available, I changed the above too:

Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity
----------- ---- ----------- ----------- ----------- ----------- ------------ --------- -----------

GeneralDescription text 16 NULL NULL 1 NULL NULL 0

I was under the impression that the text datatype in sybase allowed over 2 million characters by default. Can anyone let me know what sql statement I need to change this or if there is a different datatype I should be using. Basically I do not want to restrict the amount of data entered/displayed in this field.

Any help would be appreciated.

Thanks in advance,

Nick