[PHP-users 31666] MySQLでのエラーと文字化け

[Napura]

$B$*@$OC$K$J$j$^$9!#(BNapura$B$H?=$7$^$9!#(B

PHP$B!\(BMySQL$B$rMxMQ$7$F$*$j$^$7$F%W%m%0%i%`$r(B
$B9T$C$F$$$^$9!#(B
$BJ8;z2=$1$G9T$-5M$^$C$F5o$j$^$9!#(B

insert***** values($Sno,'$v_no','$b_no','$p_name','$p_items','$SubX')";
$B$H$7$F!"<B9T$9$k$H(B
You have an error in your SQL syntax; check the manual that corresponds to your MySQL 
server version for the right syntax to use near '$BITE`%j%7%s(B','2007-03-12 9:39:53')' at line 1

insert***** values($Sno,'$v_no','$b_no',CONVERT('$p_name' USING utf8),CONVERT('$p_items' USING utf8),'$SubX')";
$B$G$b(B
You have an error in your SQL syntax; check the manual that corresponds to your MySQL
 server version for the right syntax to use near '$BITE`%j%7%s(B' USING utf8),'2007-03-12 9:50:50')' at line 1

insert***** values($Sno,'$v_no','$b_no','`$p_name`','`$p_items`','$SubX')";
$B$H!G(B`$B!!!.!G$N$h$&$K!.!.$G$/$/$k$H%(%i!<$J$7$G5-O?$O=PMh$^$9$,(B
$B%G!<%?$r>H9g$9$k$HJ8;z2=$1$7$F(B
$B%=%k%7%*%s!a!d%c5c(BV$B%*%s(B
$B9b5!G=L55!<A!a!d9b5!Gv(I3$B5!<A(B

$B$N$h$&$K$J$C$F$$$^$9!#(B

$B2?$+BP:v$O$"$k$N$G$7$g$&$+!)(B

$B%5!<%P!<$N(BPHP$B$O(B4$B$G(B
MySQL$B$b(B4.1.0$B0J9_$H;W$$$^$9!#(B
$B%G%#%U%)%k%H$G(BUTF-$B#8$HJ9$$$F$$$^$9!#(B
$B>\:Y$OJ9$$$F$$$^$;$s!#(B

$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B