Hi, I've installed today the Mayan EDMS on ubuntu 12.04 using suggested fab script. Everything went fine until I switched the interface language to Bulgarian. When trying to add files written in Bulgarian (cyrillic letters) they were replaced with ???? - something was wrong. I checked the mayan database collation and it was created by default with latin1 collation, all the tables as well.
I had to dump the database with --add-drop-table and change collation of the tables in the sql, change the collation of the mayan database itself (ALTER DATABASE mayan charset=utf8;), then pump it back - this fixed the problem. Similar procedure for moodle database is described here: http://docs.moodle.org/24/en/Converting_your_MySQL_database_to_UTF8 I think it will be good idea to create mayan database with utf8 collation from the begining, thus preventing possible issues with multilingual documents and document names. This change would happen in file ~/fabfile/databases/mysql.py , line #9 to read: run('echo "CREATE DATABASE %(database_name)s; DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci" | mysql -u root --password=% (database_manager_admin_password)s' % env) Greetings, Emil Stoyanov -- --- You received this message because you are subscribed to the Google Groups "Mayan EDMS" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
