Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Microsoft SQL Server Functions : mssql_field_length

mssql_field_length

Get the length of a field (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
int mssql_field_length ( resource result [, int offset] )

Examples ( Source code ) » mssql_field_length

<?php
// Connect MSSQL
mssql_connect('local\SQLEXPRESS''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 type and length
echo 'The field \'age\' has a data length of ' mssql_field_length($query1);

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


    

Code Examples / Notes » mssql_field_length

08-feb-2005 09:56

You can also work around this limitation with the following:
  -- for example, with MyVarCharField VARCHAR(1000)
  SELECT CAST(MyVarCharField AS TEXT) FROM MyTable


zz lost dot childz

there are same problem with VARBINARY, if you are forced to use existing database with such fields you can do it like this:
SELECT CAST(master.dbo.fn_varbintohexstr(VARBINARYFIELD) AS TEXT) FROM table;


Change Language


Follow Navioo On Twitter
mssql_bind
mssql_close
mssql_connect
mssql_data_seek
mssql_execute
mssql_fetch_array
mssql_fetch_assoc
mssql_fetch_batch
mssql_fetch_field
mssql_fetch_object
mssql_fetch_row
mssql_field_length
mssql_field_name
mssql_field_seek
mssql_field_type
mssql_free_result
mssql_free_statement
mssql_get_last_message
mssql_guid_string
mssql_init
mssql_min_error_severity
mssql_min_message_severity
mssql_next_result
mssql_num_fields
mssql_num_rows
mssql_pconnect
mssql_query
mssql_result
mssql_rows_affected
mssql_select_db
eXTReMe Tracker