MSSQL_FIELD_LENGTH(3)													     MSSQL_FIELD_LENGTH(3)

mssql_field_length - Get the length of a field

SYNOPSIS

       int mssql_field_length (resource  $result, [int	$offset = -1])

DESCRIPTION

	Returns the length of field no. $offset in $result.

PARAMETERS

	      o $result
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

	      o $offset
		- The field offset, starts at 0. If omitted, the current field is used.

RETURN VALUES

	The length of the specified field index on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_field_length(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');

	      // Print the field length
	      echo 'The field 'age' has a data length of ' . mssql_field_length($query, 1);

	      // Free the query result
	      mssql_free_result($query);
	      ?>

	      The above example will output something similar to:

	      The field 'age' has a data length of 4

NOTES

       Note

	      Note to Windows 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.

SEE ALSO

       mssql_field_name(3), mssql_field_type(3).

PHP Documentation Group 												     MSSQL_FIELD_LENGTH(3)