我正试图将土耳其字符更改为英文字符,但它没有改变。我想在mysql数据库上执行query命令。Mysql不接受土耳其字符查询。所以我不能运行这个查询。
我的SQL查询是:
$sql_test="SELECT a.order_id as siparis_no,
a.firstname as isim,
a.lastname as soyisim,
b.name as urun_Adi
FROM zisl8_mijoshop_order a
LEFT JOIN zisl8_mijoshop_order_product b
ON a.order_id=b.order_id
WHERE a.date_added>'$t_bas' and a.date_added < '$t_bit' AND b.name='Genel Bağış'
";
我的PHP替换代码:
$replace = array('i', 's', 'o', 'c', 'g', 'u', 'I', 'G', 'O', 'C', 'S', 'U');
$search = array('ı', 'ş', 'ö', 'ç', 'ğ', 'ü', 'İ', 'Ğ', 'Ö', 'Ç', 'Ş', 'Ü');
$str='Genel Bağış';
$str=str_replace($search,$replace,$str);
我知道PHP代码没有问题。但是当试图在页面上显示echo:
时字符串显示如下'Genel Bağış'。看来我没有什么要改的了。
和MySQL查询不工作。但是当我像这样手动更改字符串时:
$sql_test="SELECT a.order_id as siparis_no,
a.firstname as isim,
a.lastname as soyisim,
b.name as urun_Adi
FROM zisl8_mijoshop_order a
LEFT JOIN zisl8_mijoshop_order_product b
ON a.order_id=b.order_id
WHERE a.date_added>'$t_bas' and a.date_added < '$t_bit' AND b.name='Genel Bagis'
";
查询正在工作。字符串'Genel Bağış'来自mysql数据库。这是为了说明我的问题。
那么我在哪里做错了,请帮助?
在每个PHP输出报头中,指定UTF-8作为编码:
header('Content-Type: text/html; charset=utf-8');
mysql_ *
$link = mysql_connect('localhost', 'user', 'password');
mysql_set_charset('utf8', $link);
mysql_*已弃用
mysqli
$mysqli = new mysqli("localhost", "my_user", "my_password", "test");
$mysqli->set_charset("utf8");
PDO
$pdo = new PDO(
'mysql:host=mysql.example.com;dbname=example_db',
"username",
"password",
array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
在MySQL方面,需要对my.ini
文件进行如下修改:
[client]
default-character-set=UTF-8
[mysql]
default-character-set=UTF-8
[mysqld]
character-set-client-handshake = false #force encoding to uft8
character-set-server=UTF-8
collation-server=UTF-8_general_ci
[mysqld_safe]
default-character-set=UTF-8