[daisy] Daisy 1.5.1 -> Daisy 2.0 with sauce

[Bruno Dumon]

On Wed, 2007-04-04 at 16:29 -0700, Caleb Callaway wrote:
> Successfully made the jump from 1.5.1 to 2.0 on a Windows XP Home (urgh)
> machine, and it is Neat! Had a couple issues that I thought would be good to
> pass along, though...
> 

<snip/>
> Finally, the wikinit script generated a strange error:
> 

<snip/>

>  type.
> Caused by:
> org.outerj.daisy.repository.clientimpl.infrastructure.DaisyPropagated
> Exception: [com.mysql.jdbc.MysqlDataTruncation] Data truncation: Data too
> long f
> or column 'value' at row 1
> 
> So that's a bit of a puzzle too.

The problem here is that the encoding (a.k.a. character set) of your
database is probably not UTF-8. The field types daisy-wiki-init tries to
create contain some descriptions in locales with strange glyphs (such as
russian) which might need multiple bytes to represent them, and it's
somewhere there that MySQL fails.

There's no easy way to solve this from Daisy (MySQL should store
unsupported characters simply as one char). The best thing I can suggest
is to switch to UTF-8.

To switch the DB to UTF-8:

 * check MySQL docs to see how to do it on the MySQL side.

 * on the Daisy-side, check that the DB-url in the myconfig.xml
specifies UTF-8 as encoding:
<url>jdbc:mysql://localhost/daisyrepository?characterEncoding=UTF-8</url>

>  I've also been unable to get the
> Daisy-as-a-Service functionality working again--changing the paths in the
> Windows registry didn't cut it. Haven't delved too deeply into that one,
> though.

See also Vincent's mail, we need to extend the upgrade instructions with
a section on this.

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought - Open Source, Java & XML Competence Support Center
bruno at outerthought.org                          bruno at apache.org