Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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±àдִÐÐlinux shellÃüÁîµÄ´úÂë

ʹÓÃPHPµÄexecº¯Êýµ÷ÓÃlinuxµÄshellÃüÁÈçdateÈ¥ÐÞ¸Äʱ¼ä»òshutdownȥʵÏֹػú/ÖØÆô£¬µ«ÊÇ·µ»ØÖµ¶¼ÊÇʧ°ÜµÄ¡£¾­¹ý¶à´ÎÊÔÑ飬È϶¨ÊÇûÓÐȨÏÞµÄÎÊÌâ¡£
ËùÒÔ£¬Ð¡µÜÔÚ´ËÇë½Ì¸÷룬ÈçºÎ²ÅÄÜÉèÖÃȨÏÞ£¬µ÷ÓÃlinux shellà ......

¸¶·ÑÇóÒ»¶Îphp´úÂ룬֧³ÖÌÔ±¦½»Ò× - PHP / Framework

¸÷λ´óÏÀ 
ÇóÒ»¶Îphp´úÂë 
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ 
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ 
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½ 
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ