[Using Sakai] Charset encoding

[Matthew Jones]

You still should be able to convert all of the tables to utf8 even if you
missed setting this up initially, either on a live system or during a short
backup/restore downtime.

This post by Nuno a few years ago suggested that he did this:
http://collab.sakaiproject.org/pipermail/sakai-dev/2009-September/003701.html

Which was based off this thread which had both self generating SQL alter
scripts as well as perl script to do it.
http://www.haidongji.com/2008/11/11/convert-character-set-to-utf8-in-mysql/

You'd probably would want to do this on a backup to make sure it works, but
I've done this type of thing on Oracle and Mysql without any issues on
development /test databases before when I forget to set UTF-8.

You also have to remember to set the correct parameters on the tomcat and
mysql connector:
https://confluence.sakaiproject.org/display/I18N/Common+UTF-8+Problems

As far as the documentation, I do see this info on the release page in on
the database support for both 2.7 and 2.8? Perhaps there was some guide or
link that this was missing from? :(

https://confluence.sakaiproject.org/display/DOC/Sakai+CLE+2.7+database+support

On Wed, Nov 23, 2011 at 2:29 PM, Nicolas Lupien <niclupien at gmail.com> wrote:

> I'm probably not the first reporting issues about character encoding
> because of the existence of this page :
> https://confluence.sakaiproject.org/display/DOC/Database+UTF-8+(2.x)
>
> But unfortunately, I discovered it too late and I must deal with not being
> able to use UTF-8 character encoding in some context in my Sakai instance.
> It's a bit of a problem because we have mostly french user with special
> character (é, è) in their name. I fear to modify the database manually
> cause i don't know what effect it can have on Sakai. Generally, I tell
> people to never modify database of system I develop (i'm a developer).
>
> However, what i would like to ask you is to put some reference to this in
> your release notes or install page. I've read it all and followed it
> carefully but still I have a broken installation. I also have good
> knowledge of system installations (I have a fresh RHEL Sysadmin II
> certification) i don't think this is a "dumb" error of myself.
>
> Don't get me wrong, I don't want to "troll" or anything, you have a
> excellent project and I know how open source project works. I'm very happy
> with what you do, and i'm also happy to getting you my first feedback.
>
> Nicolas Lupien
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20111123/e0b6cda8/attachment.html