+1 good idea. cheers L.
On Tuesday, February 26, 2013, emostoyanov wrote: > 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] <javascript:;>. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- So the future isn't a boot stamping on a human face, forever. It's a person in a beige business outfit advocating beige policies that nobody wants (but nobody can quite articulate a coherent alternative to) with a false mandate obtained by performing rituals of representative democracy that offer as much actual choice as a Stalinist one-party state. And resistance is futile, because if you succeed in overthrowing the beige dictatorship, you will become that which you opposed. http://www.antipope.org/charlie/blog-static/2013/02/political-failure-modes-and-th.html -- --- 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.
