# Convert database from utf8\_general\_ci to uft8\_unicode\_ci

**URL:** <https://forums.percona.com/t/convert-database-from-utf8-general-ci-to-uft8-unicode-ci/1432>\
**Category:** Other MySQL® Questions\
**Created:** [June 12, 2010, 4:12am UTC](https://forums.percona.com/t/convert-database-from-utf8-general-ci-to-uft8-unicode-ci/1432 "2010-06-12T04:12:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![henryvuong](https://avatars.discourse-cdn.com/v4/letter/h/f08c70/32.png) [@henryvuong](https://forums.percona.com/u/henryvuong)\
**Post date:** [June 12, 2010, 4:12am UTC](https://forums.percona.com/t/convert-database-from-utf8-general-ci-to-uft8-unicode-ci/1432/1 "2010-06-12T04:12:11Z")

</div>

I am using a database for Vietnamese language with the collation utf8\_general\_ci. Some characters are not correctly stored in the database (though they appear in the correct format on the website) so I want to change the collation to utf8\_unicode\_ci hoping it would solve the problem. How do I do that? Thanks

---

<div class="post-metadata">

**Author:** ![istvan.podor](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/istvan.podor/32/16879_2.png) [@istvan.podor](https://forums.percona.com/u/istvan.podor)\
**Post date:** [September 6, 2010, 8:01am UTC](https://forums.percona.com/t/convert-database-from-utf8-general-ci-to-uft8-unicode-ci/1432/2 "2010-09-06T08:01:33Z")

</div>

Hi there,

one of the easiest way is to define for database and table or even columns, the collation you want to use it with.

You can also change the collation for the server, database, client from your mysql configuration too.

Bests,  
Istvan