Ticket #382 (closed Task)
Charset for Daisy's (Mysql) Database(and tables) should be forcefully set to utf-8
|Reported by:||mpo@…||Owned by:||somebody|
|Component:||Repository - database support||Version:||2.0|
[jira2trac import : issue created on December 15, 2006 2:53:36 AM CET http://issues.cocoondev.org/browse/DSY-382 ]
By default a mysql installation on a debian system (ubuntu) appears still to be configured for the 'latin1' charset.
As a consequence the created database for the daisy repo (and therein all tables) are not accepting other characters then those in the latin-1 set.
Daisy's installation procedures should be adapted so we can rightfully force the required unicode features to be available and not be dependent on circumstantial default settings of the system.
We probably need to
* mention this in the docs; CREATE DATABASE daisyrepository CHARACTER SET 'utf-8'
* put this in the debian-distro scripts for the package
* maybe additionally investigate if torque can enforce charset on the created tables
* check effect on other related schema stuff (workflow and activemq tables)