[Building Sakai] Latest 2.7.x throw UTF-8 DB Error

[Warwick Chapman]

Hi All

I'm back on the horse now and trying to install the latest 2.7.x branch
(78257) but am getting the following in the catalina.out file:

<log>
FATAL main org.sakaiproject.content.impl.DbContentService - Check on
Database Failed
java.sql.SQLException: Incorrect string value: '\xC2\x80\xC2\x81\xC2\x82...'
for column 'XML' at row 1

...

FATAL main org.sakaiproject.content.impl.DbContentService - WARNING
  The connection from this instance of Sakai to the database
  has been tested and found to corrupt UTF-8 Data.
  In order for Sakai to operate correctly you must ensure that your
  database setup is correct for UTF-8 data. This includes both the
  JDBC connection to the database and the underlying storage in the
  database.
  The test that was performed on your database create a table
  wrote some data to that table and read it back again. On reading
  that data back it found some form of corruption, reported above.

 More information on database setup for sakai can be found at

http://bugs.sakaiproject.org/confluence/display/DOC/Install+Guide+-+DB+(2.4)

 Sakai Startup will continue but you might want to address this issue ASAP.
</log>

MySQL is using the InnoDB engine as recommended by Anthony Whyte and I can
confirm that the DB was successfully populated upon initial startup.

-- Warwick Bruce Chapman | +27 83 7797 094 | http://warwickchapman.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100604/e05395d8/attachment.html