Çó½Ì~~mysqlµÄÎÊÌâ - PHP / »ù´¡±à³Ì
ÎÒ½¨Á˸ö±í ÓÉÓÚÒª´æ´¢±È½Ï´óÁ¿µÄÎÄ×Ö
ËùÒÔÀàÐÍÓõÄÊÇtext
µ«ÊÇÎÒÔÚÓÃÍøÒ³ºǫ́дÈëÊý¾ÝµÄʱºòÌáʾ
Incorrect string value: '\xD5\xA2\xB7\xA7\xC6\xD0...' for column 'bt' at row 1
Ö»ÒªÓÃÖÐÎľͳöÏÖ ±àÂëÀàÐÍÎÒÓõÄÊÇGBK ÓÐûÓÐÈËÄܽâ´ðÏÂ
ת³Éutf-8ÄØ£¬²»ÕýÈ·µÄ×Ö·ûÖµ
ת³Éutf-8Ò²Ò»Ñù »¹ÊDz»ÐÐ
ÍøÒ³Ê¹ÓõıàÂëÒªºÍÊý¾Ý¿â×ֶεÄÏàͬ
Êý¾Ý¿âÒ²ÊÇGBK
ÄÜ·ñ°ÑÄǾäsql Êä³ö¡£ »á²»»áÊÇÀïÃæ³öÏÖÁË ' ÕâÖÖÌØÊâ×Ö·û¡£
ÒѾ½â¾öÁË ÓÃGBK¾ÍÊDz»³É¹¦
¸É´àÎÒÈ«¶¼¸Ä³Éutf8 Õâϳɹ¦ÁË
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÈçÌ⣬Ôõôд¸öheadÍ·²¿ ÈÃÒ³Ãæ»º´æ1ÐÇÆÚ¡£
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
Äã°ÑÀïÃæµÄʱ¼ä£¬¸Ä³Éµ±Ç°Ê±¼ä¼ÓÉÏÒ»¸öÐÇÆÚ
¼ÇµÃҪת»»³Égmtʱ¼ä
ÎÒÕâÑùдµÄ ²»ÖªµÀÐв»ÐС£
Ò»¸öÐ ......