php man page for mssql_field_length

Query: mssql_field_length

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
mssql_field_length(3) - php
mssql_field_name(3) - php
mssql_fetch_row(3) - php
mssql_field_seek(3) - php
mssql_get_last_message(3) - php
Similar Topics in the Unix Linux Community
About PHP
Convert each field to excel
mysql query multiple records for one field
Oracle query with field filter
Loop overwrite first input