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 fieldSYNOPSISint mssql_field_length (resource $result, [int $offset = -1])DESCRIPTIONReturns the length of field no. $offset in $result.PARAMETERSo $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 VALUESThe length of the specified field index on success or FALSE on failure.EXAMPLESExample #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 4NOTESNote 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 ALSOmssql_field_name(3), mssql_field_type(3). PHP Documentation Group MSSQL_FIELD_LENGTH(3)
Related Man Pages |
---|
mssql_fetch_object(3) - php |
mssql_data_seek(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 |
---|
sed/awk script |
Convert each field to excel |
mysql query multiple records for one field |
Replace a field with a character as per the field length |
Oracle query with field filter |