Announcement

Announcement Module
Collapse
No announcement yet.

Convert database from utf8_general_ci to uft8_unicode_ci

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Convert database from utf8_general_ci to uft8_unicode_ci

    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

  • #2
    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

    Comment

    Working...
    X