СµÜÎÒÔÚserver2000Êý¾Ý¿âarticle±íµ¥ÖÐÓÐÒ»¸öÀàÐÍÊÇ¡®ntext¡¯µÄ×ֶΣ¬×Ö¶ÎÃûÊÇcontext¡£´Ë×Ö¶ÎÊÇÓÃÀ´´æ·ÅÎÄÕÂÄÚÈݵģ¬ÎÒÓÃphp¶ÁÈ¡´Ë×Ö¶ÎÄÚÈÝÓÃÓï¾ä£ºPHP code:
$result=mssql_query("select convert(text,content) as content from article where articleid='$articleid' ");
´ËÓï¾ä¿ÉÒÔÕýÈ·Ö´ÐУ¬µ«ÎÊÌâÊÇÓеÄÎÄÕÂÄÚÈݺܶ࣬Óá®text¡¯Ö»ÄܶÁÈ¡´óÔ¼5000¸öºº×Ö£¬Ê£ÏµľÍÎÞ·¨ÏÔʾ£¬ÎÒ²»ÖªµÀÓÃʲô°ì·¨¿ÉÒÔ°ÑËùÓеÄÄÚÈݶ¼¶ÁÈ¡³öÀ´¡£Çë¸÷λ´ó¸ç°ï°ïæ¸øµãÒâ¼û»ò½¨Ò飬СµÜÎÒллÁË¡££¨Êý¾Ý¿âÊǹ̶¨²»ÄÜÐ޸ĵģ¬Ö»ÄÜÓÃPHP´úÂëÀ´½â¾ö¡££©
ÎÒÓÃÏÂÃæ´úÂë¶ÁÈ¡context×ֶΣº
PHP code:
while ( $row = mssql_fetch_row($result))
{
echo $row[0];
}
ÎÒ¾õµÃÊDZäÁ¿$row²»ÄÜ´æ´¢ÄÇô³¤µÄ×Ö·û£¬µ«ÎÒ²»¶®ÔõôÉ趨±äÁ¿´æ´¢×Ö·ûµÄ³¤¶È£¿
ÖÕÓÚÕÒµ½ÎÊÌâËùÔÚ£¬sql server 2000ÖÐ'text'ÀàÐÍÖ»ÄÜ´æ´¢4096¸ö×Ö·û£¬ËùÒÔ'ntext'×°»»³É¡®text¡¯ÀàÐͺ󣬳¬¹ý4096×Ö·ûºóÃæµÄ×Ö·ûÈ«²¿¶¼¶ªÊ§¡£´ó¼ÒÓÐʲô°ì·¨Äܹ»È«²¿¶ÁÈ¡Íê'ntext'ÀàÐÍ×ֶεÄËùÓÐÄÚÈÝ£¿
ÎÊÌâ½â¾ö£¬·½·¨ÈçÏ£º
PHPÔÚ²Ù×÷SQL ServerÊý¾Ý¿âʱ,Ö»ÄÜ·¢ËÍ4096BµÄ×Ö·û,Èç¹û°´ÕÕÕâ¸öÉèÖÃ,ÔÚ·¢²¼Ò»Ð©ÄÚÈݱȽϳ¤µÄÐÅϢʱ,»áµ¼ÖÂÐÅÏ¢²»È«,Òò´Ë,ÐèÒªÐÞ¸Äphp.iniÖÐÏà¹ØµÄÉèÖÃ:
ÓÃÈÎÒâÎı¾±à¼Æ÷´ò¿ªphp.ini,
ÕÒµ½
;mssql.textlimit = 4096
¸ÄΪ
mssql.textlimit = 2147483647
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......