Dear group members,

I have a field of type varchar[1000] in a sql server database. I use the
below syntax to get it from the database.The length of the string is 288 in
this case.

When i do the selection and store the value in a variable. On printing the
variable it only outputs 255 characters. Is there a limit to the amount of
data a variable can store ?? If yes then how can i use a string longer then
255 in my database??

$sql="select sql from report_tbl where report_id = '".$id."'";
$result=mssql_query($sql);
$row=mssql_fetch_array($result);
echo $row["sql"];

$row["sql"] outputs 255 characters as opposed to 288 which is the actual
length of the sql stirng.

Please help.

Thanks,

Regards,
Harpreet Kaur


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to