SQL Server 2000 - unable to select more than 255 characters from a text field
Posted on 2003-11-04
I have a table which contains a column with data type of 'text'. I can insert a large amount of data into this column - currently up to 3000 characters - which can be verified by selecting the 'len' value. I cannot, however, select more than 255 characters from this column at one time.
After some research I have checked:
select @@textsize which returns the result 64512
My question is about the DB-Library function 'dbsetopt'. It appears that one of the options that can be set using this function is DBTEXTLIMIT. Could this be governing the amount of text I can select - and if so how can I find out what it is set to currently and change it?
I can select chunks of 255 from the field as a work around.