problem with mysql database character set

[netseeker]

hi,

I create a mysql database using DA and database character set is : latin1_swedish_ci

whereas I have to create a database with this kind of collation :
utf8_persian_ci

and I don't have any idea of how to create or change collation to utf8_persian_ci

just to make it clear I have taken a screenshot from what I mean :

http://www.mediafire.com/imgbnc.php...9154ad540a9cad1476c696364ef3b419f8d73506g.jpg

cheers

 

[netseeker]

I found the solution

http://kb.siteground.com/article/How_can_I_change_my_MySQL_database_collation.html

cheers.

 

[elaine]

If you need in format in utf8 in your DA server, just add the link as below in my.cnf config file:

[mysqld]
local-infile=0
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_unicode_ci

By the way, remember to backup the old config file first.