PHP - Stings Getting Truncated

need your suggestion here is my problem i have field varchar(1000) in my sql server 2008 DB but if i mssql_fetch_object($result) my field value truncated and only show 256 character, why ?
in my DB . my field value really 1000 character long .

Hello PHP geniuses,

I'm having a bit of trouble here. I've built a WYSIWYG e-mail editor with the help of TinyMCE. I'm using a textarea to pull the innerHTML from the iframe where the actual editor is.

The textarea will be hidden in production, but it's shown now for debugging reasons. I have a JS function that grabs the HTML from the iframe and puts it into the textarea, and this works great. The entire HTML gets populated in the textarea. When I go to save the e-mail (using a simple query that posts it and sends it straight to the database). The HTML is truncated in the database field to around ~255 characters. (it varies depending on what I have in there, but it's usually between 252 and 255)

I really can't figure out why this would be cutting off like this. I've looked everywhere, I don't know what else to do.


I wanted to add that the field is a text field in the database, that was the first and most obvious thing to check. I can confirm that my database holds the full text no problem. I can go into phpMyAdmin and copy+paste infinite amounts of data into the html field and it saves it without an issue.


Thank you as always <3

If you need more information to help me, I will provide whatever helps.

Hi, the problem that I have goes like this. If i do a regular Select query and display it in a table everything is there but if i am filling a input box of a form to use for modifying the values it does not return the entire value:

Exemple with the same value
in a table = product_name : Amd Athlon X2
In input field : Amd

Here is my code
Code: [Select]
<?
$sql = "SELECT * FROM tbl_product WHERE product_code = '$_POST[productcode]'";
$result = mysql_query($sql);
if(!$result){
die("Error running $sql:" . mysql_error());
}
?>


<?
 while($row = mysql_fetch_array($result))
 {
echo "
<form action='functions/moditem.php' method='post'>
<input type='hidden' name='productid' value=". $row['product_id'] .">
Product code : <input type='text' name='productcode' value=". $row['product_code'] ." /><br />
Product Name : <input type='text' name='productname' value=". $row['product_name'] ." /><br />
Product Price: <input type='text' name='productprice' value=". $row['product_price'] ." /><br />
<input type='submit' value='Modify' />
</form>
";
}

Hi Guys,

My 2nd issue with my new blog is that the code used to limit the amount of content displayed from each post, is on occasion truncating the closing html tags along with the excess text! Very often this will result in any following posts being entirely italic or bold, which as you can imagine looks ridiculous.
The Code that limits the content:
# Limit Post
function the_content_limit($max_char, $more_link_text = '', $stripteaser = 0, $more_file = '') {
    $content = get_the_content($more_link_text, $stripteaser, $more_file);
    $content = apply_filters('the_content', $content);
    $content = str_replace(']]>', ']]&gt;', $content);
    $content = strip_tags($content, '<h1>,<h2>,<h3>,<strong>,<em>, ');
   if (strlen($_GET['p']) > 0) {
 

I'd be very grateful if someone could help me out with this.
Thanks Steve