You can also work around this limitation with the following:
-- for example, with MyVarCharField VARCHAR(1000)
SELECT CAST(MyVarCharField AS TEXT) FROM MyTable
mssql_field_length
Description
int mssql_field_length ( resource result [, int offset] )This function returns the length of field no. offset in result result. If offset is omitted, the current field is used.
Note to Win32 Users: Due to a limitation in the underlying API used by PHP (MS DbLib C API), the length of VARCHAR fields is limited to 255. If you need to store more data, use a TEXT field instead.
add a note
User Contributed Notes
09-Feb-2005 05:56