Hello all:

I am developing an app. I try to upload a file such as *.text into a colume with text type in a table in a database using the UpFile control.It failed.But I find that I can upload the same file into anther colume with image type in the same table.

Can anybody help?

thanks
kejun

You are trying to pass a string that is longer than the allowable lenght fot your field.
Either change the field type on the database to a larger field (even blob) or do not allow such a long string to be uploaded to your database.
An image field is a Blob field and it is very large, that is the reason that you are able to load it into that image field.

Sal

Thanks for your opinion.

I think the size of text field for SQL Server database is supposed to be about 4GB.But the size of the file I try to upload is less than 1MB. Most of all,I want to build up a full-text index on the field.I don't think the image field is a full-text indexed field.

you'd better write to sal if you know his email address, it seems that no other guys can help.