<div>
Thanks for your comment.<br />
I read the articles and for creating new db i used comand line as:<br />
CREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;<br />
and it is good,now can you guide that how can apply this to an existance db?<br />
<br />
<br />

</div>


Thanks for your comment.
I read the articles and for creating new db i used comand line as:
CREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;
and it is good,now can you guide that how can apply this to an existance db?




<div>
Check this article, it'll help you<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html</a>
</div>


Check this article, it'll help you

http://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html [http://dev.mysql.com/doc/refman/5.0/en/charset-conversion.html]

<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
I have created several db with character set of utf8 for multilanguage<br />
support,but from yesterday that i creat a new db ,i set character set<br />
in Mysql Administrator to utf8 and utf8_general_ci but when i want<br />
type persian i receive error 1366 ,when i see table options in Mysql <br />
<br />
Administrator it is ok and is on utf8, but i try change the &quot;NOT NULL&quot;<br />
and that in the box of Execute there is this message:<br />
<br />
ALTER TABLE `testi`.`tbtest` MODIFY COLUMN `title` VARCHAR(45) CHARACTER SET <br />
<br />
latin1 COLLATE latin1_swedish_ci;<br />
<br />
so it seems that character set is locked to above (SWedish),is there any<br />
solution?<br />
Thanks
</div>
</div>


Hello all,

I have created several db with character set of utf8 for multilanguage
support,but from yesterday that i creat a new db ,i set character set
in Mysql Administrator to utf8 and utf8_general_ci but when i want
type persian i receive error 1366 ,when i see table options in Mysql 

Administrator it is ok and is on utf8, but i try change the "NOT NULL"
and that in the box of Execute there is this message:

ALTER TABLE `testi`.`tbtest` MODIFY COLUMN `title` VARCHAR(45) CHARACTER SET 

latin1 COLLATE latin1_swedish_ci;

so it seems that character set is locked to above (SWedish),is there any
solution?
Thanks

Character set has been locked to Latin1  Latin1_swedish_ci ?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.