Handling very long strings
Posted on 2002-05-16
I have seem to run into a problem that I don't know how to handle.
I am using Sql 7.0 for the database backend, and I store very long strings in a field defined as text. When I pull this data into a string variable, it only retrieves about 1300 characters of data. Im not sure if its the field definition or the variable definition that I'm having a problem with. As long as the data is smaller than 1300 characters, it works fine.
Data is stored as such:
I pull this into a string variable then run a sql statement as such:
Select * from tablename where fieldname in (Variable).