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

[mpo@…]

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

[paul]

[jira2trac import : comment created by paul on December 15, 2006 3:36:27 AM CET]

• 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

[anonymous]

I'm not sure if all these crazy health and beauty things that celebrities do actually work, but it's still pretty interesting to hear about the things people will do to make themselves as perfect as possible.There is a long list of possible risks and consequences for a baby whose mother smoked while pregnant.One way to lose pregnancy weight quickly is to drink 10-12 glasses of water. ​pregnancy diet restrictions There's even a Cannabis Cafe that opened up in Portland, testing a new federal policy not to prosecute medical users (Oregon state law allows for medical marijuana usage) despite use and possession of marijuana still being illegal on the federal level.She] was now known and talked about over Big Macs and fries under the Golden Arches by young fashionistas in Wal-Mart denim in Davenport and Dubuque.From this point of view, it provided convenience for people.However, without using dangerous diet pills or ineffective or hard to implement diet strategies, diet tea will replace high-calorie beverages and combine weight loss results along with many other healthful side effects.As all the ingredients is all-natural, it is definitely safe to consume.