这是config.php
<?
define('DB_SERVER', 'loalhost');
define('DB_USER', 'root');
define('DB_PASS', 'pass');
define('DB_NAME', 'dbname');
define('mysql_set_charset','utf8');
define('mysql_query','SET NAMES utf8_persian_ci');
?
当我将阿拉伯语或波斯语文本插入数据库时,格式发生了变化。我如何保持文本在数据库中插入相同的格式。
对
您需要确保整个数据库的字符集是正确的。这意味着检查所有3层,数据库,表和列。使用utf8
&utf8_general_ci
将适用于您的阿拉伯语和波斯语文本。
下面的查询可以用来检查数据库中每个对象的字符集,你也可以在大多数GUI应用程序中轻松检查和更改它们。
列SELECT character_set_name
FROM information_schema.COLUMNS
WHERE table_schema = "YOUR_SCHEMA"
AND table_name = "YOUR_TABLE"
AND column_name = "YOUR_COLUMN";
表SELECT collations.character_set_name
FROM information_schema.TABLES AS tables,
information_schema.COLLATION_CHARACTER_SET_APPLICABILITY AS collations
WHERE collations.collation_name = tables.table_collation
AND tables.table_schema = "YOUR_SCHEMA"
AND tables.table_name = "YOUR_TABLE";
数据库(模式)
SELECT default_character_set_name
FROM information_schema.SCHEMATA
WHERE schema_name = "YOUR_SCHEMA";