業(yè)務(wù)場景:php頁面呼叫mysql預(yù)存程序,有1個入?yún)ⅲ?個出參。
出現(xiàn)問題:能正常執(zhí)行,但入?yún)①Y料庫後總是顯示亂碼。
PHP頁面程式碼如下
<head> <meta charset="utf-8"> </head> <?php $conn = new MySQLi("數(shù)據(jù)庫地址","數(shù)據(jù)庫用戶","密碼","數(shù)據(jù)庫名"); mysqli_query($conn,"SET NAMES utf8"); $info_name_cn='測試x201'; $info_name_cn=mb_convert_encoding($info_name_cn,'UTF-8'); $result=$conn->query("CALL x2('$info_name_cn',@exeout_rows)"); $result=$conn->query("SELECT @exeout_rows"); $recordset=mysqli_fetch_assoc($result); $exeout_rows=(int)$recordset["@exeout_rows"]; ?> <div>---|<?php echo $exeout_rows; ?>|<?php echo mb_detect_encoding($exeout_rows); ?>|---</div>
mysql預(yù)存程序程式碼如下
CREATE DEFINER=`數(shù)據(jù)庫名`@`%` PROCEDURE `x2`( IN exein_info_name_cn VARCHAR(5) ,OUT exeout_rows int ) BEGIN set exeout_rows=1; insert into 測試表 ( info_name_cn ) values ( exein_info_name_cn ); END
mysql資料庫中,測試表的選項為"utf8/ utf8_ganaral_ci",測試表內(nèi)部字段info_name_cn的字元集?
*.php檔案編碼問題