6 UTF UTF






1- 2 ( )
2-
3- php , WHMCS .
4- notepad++




:


1- WHMCS
2-




:

mysqldump --default-character-set=latin1 --opt db_name > db_name.sql
3- Notepad++
4- (CTRL+A)
5- (CTRL+X)
6- Encoding
7- Encode in UTF-8 without bom
8- (CTRL+V)
9-
10-
11-
:

mysql db_name < db_name.sql
12- tblknowledgebase
:

mysql db_name alter table tblknowledgebase drop index `title`; exit
13-
PHP:
$username = 'USERNAME';
$password = 'PASSWORD';
$database = 'whmcs';

14-
:

php convertutf.php > php.output.sql
php.output.sql

, NOT NULL DEFAULT NULL
NOT NULL




NULL DEFAULT NULL

NULL



15-

:

mysql db_name < php.output.sql
16- tblknowledgebase
:

mysql db_name alter table tblknowledgebase add FULLTEXT KEY `title` (`title`,`article`); exit
17- , Setup general Settings Localisation
18- UTF-8



UTF-8




UTF-8
hostpress : http://hardlayers.com/lang/ar.txt


, tpl UTF
UTF notepad++

, , , ,,



, UTF