• Use mySQL version 8.0 - character set UTF8MB4

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #53113  by BOB
 
When installing OpenKM, I used the current MySql version 8.0. When creating the database with the command "CREATE DATABASE okmdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;" the following warning is issued:
Code: Select all
"1 row(s) affected, 2 warning(s): 3719 'utf8' is currently an alias for the UTF8MB3 character set, but will be an alias for UTF8MB4 in a future release. 
Please consider using UTF8MB4 to be unique. 3778 'utf8_bin' is a collation of the deprecated UTF8MB3 character set. 
Please consider using UTF8MB4 with an appropriate collation instead. 0.015 sec"
Should or can the create command also be executed with UTF8MB4 or UTF8MB4_bin?
 #53141  by jllort
 
However, consider when declaring a column in a table like varchar(100) -> you are reserving size in bytes. If you do not need 4bytes to store your language I suggest using old utf8 what uses only 3 bytes. Maybe some article about "mysql varchar bytes" will give some clue about what happens in the database storage:

* https://stackoverflow.com/questions/199 ... -and-utf-8
* https://dev.mysql.com/doc/refman/8.0/en/char.html
* https://www.mysqltutorial.org/mysql-varchar/

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.