PHP¹ØÓÚSQLserverÊý¾Ý¿âÖÐ'ntext'×ֶζÁÈ¡
ÒòΪÔÚphpÖв»Ö§³ÖSQLserver2000Êý¾Ý¿âµÄ'ntext'ÀàÐ͵ÄÊý¾Ý£¬ËùÒÔÒª¶ÁÈ¡Êý¾Ý¿âÖÐ'ntext'ÀàÐÍ×Ö¶ÎʱֻÓÃ'text'À´´úÌæ'ntext'½øÐжÁÈ¡£¬´úÂëÈçÏ£º
PHP code:
$result=mssql_query("select convert(text,content) as content,title from article where articleid='$articleid' ");
////contentÊÇ'ntext'ÀàÐ͵Ä×Ö¶Î
ÏÖÔÚÎÊÌâ¾ÍÊÇ'text'Ö»ÄÜ´æ´¢4096¸ö×Ö·û£¬4097ÒÔºóµÄ×Ö·û¾ÍÈ«²¿¶ªÊ§ÁË¡£¸÷λ´ó¸çÓÐʲô°ì·¨Äܹ»È«²¿¶ÁÈ¡'ntext'µÄËùÓÐÄÚÈݵİ취Âð£¿Ð¡µÜÎÒÔÚ´ËллÁË£¡
sql 2000 varchar() »¹ 8000 ¸ö
ÎÒÒ²¾õµÃ'text'ÊDZ¸×¢ÐÍ£¬Ó¦¸ÃÄÜ´æ´¢ÉÏÒÚ¸ö£¬µ«ÎÒÓÃÉÏÃæµÄPHP´úÂë¾ÍÊÇ×î¶àÄܶÁÈ¡4096¸ö×Ö·û£¬ÎÒÒ²²»ÖªµÀΪʲôÕâÑù¡£¡£¡£¡£¡£
ÎÊÌâ½â¾ö£¬·½·¨ÈçÏ£º
PHPÔÚ²Ù×÷SQL ServerÊý¾Ý¿âʱ,Ö»ÄÜ·¢ËÍ4096BµÄ×Ö·û,Èç¹û°´ÕÕÕâ¸öÉèÖÃ,ÔÚ·¢²¼Ò»Ð©ÄÚÈݱȽϳ¤µÄÐÅϢʱ,»áµ¼ÖÂÐÅÏ¢²»È«,Òò´Ë,ÐèÒªÐÞ¸Äphp.iniÖÐÏà¹ØµÄÉèÖÃ:
ÓÃÈÎÒâÎı¾±à¼Æ÷´ò¿ªphp.ini,
ÕÒµ½
;mssql.textlimit = 4096
¸ÄΪ
mssql.textlimit = 2147483647
ÕÒµ½
;mssql.textsize = 4096
¸ÄΪ
mssql.textsize = 2147483647
±£´æºó,ÖØÐÂÆô¶¯WWW·þÎñ,¸ÃÉèÖü´¿ÉÉúЧ.
Ïà¹ØÎÊ´ð£º
ʹÓÃPHPµÄexecº¯Êýµ÷ÓÃlinuxµÄshellÃüÁÈçdateÈ¥ÐÞ¸Äʱ¼ä»òshutdownȥʵÏֹػú/ÖØÆô£¬µ«ÊÇ·µ»ØÖµ¶¼ÊÇʧ°ÜµÄ¡£¾¹ý¶à´ÎÊÔÑ飬È϶¨ÊÇûÓÐȨÏÞµÄÎÊÌâ¡£
ËùÒÔ£¬Ð¡µÜÔÚ´ËÇë½Ì¸÷룬ÈçºÎ²ÅÄÜÉèÖÃȨÏÞ£¬µ÷ÓÃlinux shellà ......
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......