Length question
| From: | Harpreet | Date: | Sat, 05 Jul 2003 05:22:08 +0000 |
| Subject: | Length question | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-20690@lists.php.net to get a copy of this message | ||
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