[daisy] [JIRA] Created: (DSY-382) Charset for Daisy's (Mysql) Database(and tables) should be forcefully set to utf-8

[Marc Portier (JIRA)]

Charset for Daisy's (Mysql) Database(and tables) should be forcefully set to utf-8
----------------------------------------------------------------------------------

         Key: DSY-382
         URL: http://issues.cocoondev.org//browse/DSY-382
     Project: Daisy
        Type: Task
  Components: Database support, Repository  
 Reporter: Marc Portier
    Priority: Minor


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)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira