MySQL和PHP:utf-8帶有西里爾字符我試圖在MySQL表中插入一個Cyrilic值,但是編碼存在問題。PHP:<?php
$servername = "localhost";$username = "a";$password = "b";$dbname = "c";$conn = new mysqli($servername, $username, $password, $dbname);mysql_query("SET NAMES 'utf8';"); mysql_query("SET CHARACTER SET 'utf8';"); mysql_query("SET SESSION collation_connection = 'utf8_general_ci';"); if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);} $sql = "UPDATE `c`.`mainp` SET `search` = 'test тест' WHERE `mainp`.`id` =1;";if ($conn->query($sql) === TRUE) { }$conn->close();?>MySQL:| id | search | | 1 | test D°D2 |注意:PHP文件是utf-8,數據庫排序utf8_general_ci
添加回答
舉報
0/150
提交
取消