Customers
User information
 Loading ...
Show article in Knowledge Base

 Solve encoding problem on MySQL Export knowledge base Export     SubscribeSubscribe      Show article info

If you have problems with languages such as Russian or Chinese in VisionFlow and are using MySQL then your database may be installed with the wrong character set.

 

To solve this you need to change the character encoding on the database. See steps below :

 

  • Check for character encoding (https://www.blueboxcloud.com/insight/blog-article/getting-out-of-mysql-character-set-hell)
  • Set character encodings as utf-8 at MySql.ini file if it's not set as utf-8 (http://stackoverflow.com/questions/4404768/cant-insert-russian-text-into-mysql-database)
  • Convert DB and tables into utf-8 with the HeidiSql or manual scripts if it's not set as utf-8 (http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8)
  • Restart DB and application

User comments
 Loading ...