|
|
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)