大字段数据的sql 不能在php +sqlserver2005下执行
大字段数据的sql 不能在php +sqlserver2005下执行
代码如下 （同样的代码在mysql正常）
<?php
function rmdie($str)
{
echo $str;
exit;
}
$conn=mssql_connect("CNUCTAPP114","test","test");
mssql_select_db("bureau",$conn);
//$sql="insert ab values(4,5)";
$sql='SELECT id,Ð?¨®?¡À¡§??¨ª¡¤_2¨¦?¡¥?-¨°¨°,Ð?¨®?¡À¡§??¨ª¡¤_¡À¡§??¡À¨¤o?,Ð?¨®?¡À¡§??¨ª¡¤_¡À¡§??¨º¡À??,??¨¨?¨¦¨ª¡¤YÐ??¡é_Ð???,??¨¨?¨¦¨ª¡¤YÐ??¡é_?¡è??,Ð??¡é??¨°a_¨°¨¬¨°¨¦????,¨°?ÐÐÐ?¨®?_Ð?¨®??¡§_Ð?¨®??¡§????,¨°?ÐÐÐ?¨®?_Ð?¨®??¡§_?a?¡ì¨¨?ƨ²,¨°?ÐÐÐ?¨®?_Ð?¨®??¡§_?¨º?¡ì¡Á¡ä¨¬?,¨°?ÐÐÐ?¨®?_Ð?¨®??¡§_????¨ª??¡ì¨®¨¤??,¨°?ÐÐÐ?¨®?_Ð?¨®??¡§_?t¨º??????¨²?¡Â??¨ª??¡ì¡Á¨¹??¡Á¡ä??,_¦Ì?Ð?_?a?¡ì?¨ª??¡ì???_¦Ì¡ê¡À¡ê¡¤?¨º?1,¨°?ÐÐÐ?¨®?_¡ä???_?a?¡ì¨¨?ƨ²1,¨°?ÐÐÐ?¨®?_¡ä???_?¨º?¡ì¡Á¡ä¨¬?1,¨°?ÐÐÐ?¨®?_¡ä???_?1???¨¹Æ¨²1,¨°?ÐÐÐ?¨®?_¡ä???_????¡ä???¨®¨¤??1,¨°?ÐÐÐ?¨®?_¡ä???_¨º¡ê¨®¨¤?1????¨ºy1,¨°?ÐÐÐ?¨®?_¡ä???_Ð-?¡§???1????1,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1???e??1,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1??¨¨?ƨ²1,¨°?ÐÐÐ?¨®?_¡ä???_????¨¤??ƨ®aƨ²1,¨°?ÐÐÐ?¨®?_¡ä???_?t¨º??????¨²?¡Â???1??¡Á¡ä??1,¨°?ÐÐÐ?¨®?_¡ä???_¨ª??¡¤¨¤¨²¨º¡¤1,¨°?ÐÐÐ?¨®?_¡ä???_Ð??¡é??¨¨?¨¨?ƨ²1,¨°?ÐÐÐ?¨®?_¡ä???_¡ä???????2,¨°?ÐÐÐ?¨®?_¡ä???_¡ä????e??2,¨°?ÐÐÐ?¨®?_¡ä???_¦Ì¡ê¡À¡ê¡¤?¨º?2,¨°?ÐÐÐ?¨®?_¡ä???_?a?¡ì¨¨?ƨ²2,¨°?ÐÐÐ?¨®?_¡ä???_?¨º?¡ì¡Á¡ä¨¬?2,¨°?ÐÐÐ?¨®?_¡ä???_?1???¨¹Æ¨²2,¨°?ÐÐÐ?¨®?_¡ä???_????¡ä???¨®¨¤??2,¨°?ÐÐÐ?¨®?_¡ä???_¨º¡ê¨®¨¤?1????¨ºy2,¨°?ÐÐÐ?¨®?_¡ä???_Ð-?¡§???1????2,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1???e??2,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1??¨¨?ƨ²2,¨°?ÐÐÐ?¨®?_¡ä???_????¨¤??ƨ®aƨ²2,¨°?ÐÐÐ?¨®?_¡ä???_?t¨º??????¨²?¡Â???1??¡Á¡ä??2,¨°?ÐÐÐ?¨®?_¡ä???_¨ª??¡¤¨¤¨²¨º¡¤2,¨°?ÐÐÐ?¨®?_¡ä???_Ð??¡é??¨¨?¨¨?ƨ²2,¨°?ÐÐÐ?¨®?_¡ä???_¡ä???????3,¨°?ÐÐÐ?¨®?_¡ä???_¡ä????e??3,¨°?ÐÐÐ?¨®?_¡ä???_¦Ì¡ê¡À¡ê¡¤?¨º?3,¨°?ÐÐÐ?¨®?_¡ä???_?a?¡ì¨¨?ƨ²3,¨°?ÐÐÐ?¨®?_¡ä???_?¨º?¡ì¡Á¡ä¨¬?3,¨°?ÐÐÐ?¨®?_¡ä???_?1???¨¹Æ¨²3,¨°?ÐÐÐ?¨®?_¡ä???_????¡ä???¨®¨¤??3,¨°?ÐÐÐ?¨®?_¡ä???_¨º¡ê¨®¨¤?1????¨ºy3,¨°?ÐÐÐ?¨®?_¡ä???_Ð-?¡§???1????3,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1???e??3,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1??¨¨?ƨ²3,¨°?ÐÐÐ?¨®?_¡ä???_????¨¤??ƨ®aƨ²3,¨°?ÐÐÐ?¨®?_¡ä???_?t¨º??????¨²?¡Â???1??¡Á¡ä??3,¨°?ÐÐÐ?¨®?_¡ä???_¨ª??¡¤¨¤¨²¨º¡¤3,¨°?ÐÐÐ?¨®?_¡ä???_Ð??¡é??¨¨?¨¨?ƨ²3,¨°?ÐÐÐ?¨®?_¡ä???_¡ä???????4,¨°?ÐÐÐ?¨®?_¡ä???_¡ä????e??4,¨°?ÐÐÐ?¨®?_¡ä???_¦Ì¡ê¡À¡ê¡¤?¨º?4,¨°?ÐÐÐ?¨®?_¡ä???_?a?¡ì¨¨?ƨ²4,¨°?ÐÐÐ?¨®?_¡ä???_?¨º?¡ì¡Á¡ä¨¬?4,¨°?ÐÐÐ?¨®?_¡ä???_?1???¨¹Æ¨²4,¨°?ÐÐÐ?¨®?_¡ä???_????¡ä???¨®¨¤??4,¨°?ÐÐÐ?¨®?_¡ä???_¨º¡ê¨®¨¤?1????¨ºy4,¨°?ÐÐÐ?¨®?_¡ä???_Ð-?¡§???1????4,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1???e??4,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1??¨¨?ƨ²4,¨°?ÐÐÐ?¨®?_¡ä???_????¨¤??ƨ®aƨ²4,¨°?ÐÐÐ?¨®?_¡ä???_?t¨º??????¨²?¡Â???1??¡Á¡ä??4,¨°?ÐÐÐ?¨®?_¡ä???_¨ª??¡¤¨¤¨²¨º¡¤4,¨°?ÐÐÐ?¨®?_¡ä???_Ð??¡é??¨¨?¨¨?ƨ²4,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥?-¨°¨°1,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥¨¨?ƨ²1,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥?-¨°¨°2,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥¨¨?ƨ²2,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_¦Ì??¡¤Ð¨°o?,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_¦Ì??¡¤?¡Â??,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_Ð??¡é??¨¨?¨¨?ƨ²,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_¦Ì??¡¤Ð¨°o?1,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_¦Ì??¡¤?¡Â??1,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_Ð??¡é??¨¨?¨¨?ƨ²1,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_¦Ì??¡¤Ð¨°o?2,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_¦Ì??¡¤?¡Â??2,??¨¨?¨¦¨ª¡¤YÐ??¡é_¦Ì??¡¤_Ð??¡é??¨¨?¨¨?ƨ²2,¨°?ÐÐÐ?¨®?_¡ä???_¡ä???????5,¨°?ÐÐÐ?¨®?_¡ä???_¡ä????e??5,¨°?ÐÐÐ?¨®?_¡ä???_¦Ì¡ê¡À¡ê¡¤?¨º?5,¨°?ÐÐÐ?¨®?_¡ä???_?a?¡ì¨¨?ƨ²5,¨°?ÐÐÐ?¨®?_¡ä???_?¨º?¡ì¡Á¡ä¨¬?5,¨°?ÐÐÐ?¨®?_¡ä???_?1???¨¹Æ¨²5,¨°?ÐÐÐ?¨®?_¡ä???_????¡ä???¨®¨¤??5,¨°?ÐÐÐ?¨®?_¡ä???_¨º¡ê¨®¨¤?1????¨ºy5,¨°?ÐÐÐ?¨®?_¡ä???_Ð-?¡§???1????5,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1???e??5,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1??¨¨?ƨ²5,¨°?ÐÐÐ?¨®?_¡ä???_????¨¤??ƨ®aƨ²5,¨°?ÐÐÐ?¨®?_¡ä???_?t¨º??????¨²?¡Â???1??¡Á¡ä??5,¨°?ÐÐÐ?¨®?_¡ä???_¨ª??¡¤¨¤¨²¨º¡¤5,¨°?ÐÐÐ?¨®?_¡ä???_Ð??¡é??¨¨?¨¨?ƨ²5,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_¨°Æ?¡¥¨ª¡§Ð?????2,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_?a?¡ì¨¨?ƨ²2,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_¡Á¡ä¨¬?2,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_?¡¤¡¤??e??2,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_?¡¤¡¤?¡ä?¨ºy2,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_Ð??¡é??¨¨?¨¨?ƨ²2,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_1¡è¡Á¡ÂШ°o?3,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_1¡è¡Á¡Â?¡Â??3,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_?¡ã¨°¦Ì3,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_Ð??¡é??¨¨?¨¨?ƨ²3,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_1¡è¡Á¡ÂШ°o?4,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_1¡è¡Á¡Â?¡Â??4,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_?¡ã¨°¦Ì4,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_Ð??¡é??¨¨?¨¨?ƨ²4,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥?-¨°¨°3,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥¨¨?ƨ²3,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥?-¨°¨°4,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥¨¨?ƨ²4,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_¨°Æ?¡¥¨ª¡§Ð?????3,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_?a?¡ì¨¨?ƨ²3,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_¡Á¡ä¨¬?3,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_?¡¤¡¤??e??3,¡¤?¨°?ÐÐÐ?¨®?_¦Ì?Ð?_?¡¤¡¤?¡ä?¨ºy3,¡¤1???e??8,¨°?ÐÐÐ?¨®?_¡ä???_¡Á??¨¹?1??¨¨?ƨ²7,¨°?ÐÐÐ?¨®?_¡ä???_????¨¤??ƨ®aƨ²8,¨°?ÐÐÐ?¨®?_¡ä???_?t¨º??????¨²?¡Â???1??¡Á¡ä??8,¨°?ÐÐÐ?¨®?_¡ä???_¨ª??¡¤¨¤¨²¨º¡¤8,¨°?ÐÐÐ?¨®?_¡ä???_Ð??¡é??¨¨?¨¨?ƨ²8,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_1¡è¡Á¡ÂШ°o?5,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_1¡è¡Á¡Â?¡Â??5,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_?¡ã¨°¦Ì5,??¨¨?¨¦¨ª¡¤YÐ??¡é_1¡è¡Á¡Â¦Ì£¤??_Ð??¡é??¨¨?¨¨?ƨ²5,??¨¨?¨¦¨ª¡¤2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥?-¨°¨°12,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥¨¨?ƨ²12,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥?-¨°¨°13,2¨¦?¡¥Ð??¡é_2¨¦?¡¥????_2¨¦?¡¥¨¨?ƨ²13 FROM tmp_71747;
$res=mssql_query($sql) or rmdie("555");
//die("$sql");
$dd=mssql_fetch_array($res);
echo $dd[1].$dd[2].$dd[3].$dd[0];
mssql_close(); //1?¡À?¨ºy?Y?a¨¢??¨®
$maxids="977";
//header("Location:b_comp.php?ids=$maxids");//exit;
?>
Ð??¡é_2ÐÅÏ¢_²éѯ¼ 是中文字段名，大概有100-200左右的字段
（这条语句在sqlserver下正常通过，能取全部数据，但是在代码里不通过，mysql+php同样代码可以通过）
什么原因？？？如何修改
|
