PHP: mssql_field_length - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

mssql_field_name mssql_fetch_row

Last updated: Fri, 26 Jan 2007

view this page in

# mssql_field_length

(PHP 3 >= 3.0.3, PHP 4, PHP 5)

mssql_field_length -- Get the length of a field

## 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
mssql_field_length
08-Feb-2005 01:56
`You can also work around this limitation with the following:
-- for example, with MyVarCharField VARCHAR(1000)
SELECT CAST(MyVarCharField AS TEXT) FROM MyTable`
add a note
mssql_field_name mssql_fetch_row

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST