well I have a MsSQL database built by contracted company and using there vb app we insert data into the fields, one of the fields is set on the MsSql admin to allow 1300 characters record but when I use php to query it and return the contents I only receive the first 255 characters I can understand this if the field in the table was set to 255 but it isn't its set to 1300, so then I thought it may be down to the php.ini settings under text size but hasn't made a difference, my commands are standard... connect to db -- $db = mssql_connect("server");
then select db -- Mssql_select_db("mydb", $db);
then the sql statement -- $result = mssql_query("SELECT * FROM mytable",$db);
,then put result of required field into variable -- $var = mssql_result($result,$num_row,"field_name");
but like I say I get only first 255 characters.
thnaks for any light you can shed on this ive probley missed something, but i do the same routines with mysql it works fine as if php isnt reading the lengths off the mssql fields.
