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

[Paul Focke (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-382?page=all ]
     
Paul Focke resolved DSY-382:
----------------------------

    Fix Version: public - 2.0
     Resolution: Fixed

* The documentation already states the use of utf8 for database creation
* Fixed debian distro scripts to force the use of utf8 for the activemq and repository databases
* Torque doesn't seem to allow the specification of character sets in its db create schema

> 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
>      Fix For: public - 2.0

>
> 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