[Using Sakai] Charset encoding

[Nicolas Lupien]

Thank you for your links, i'll try it out.

I just noticed the section you are referring to seems broken on 2.8 Release
Notes I followed for my installation :
https://confluence.sakaiproject.org/display/DOC/Sakai+CLE+2.8+release+notes

Should I report a bug or something ?

Nicolas Lupien



On Wed, Nov 23, 2011 at 2:48 PM, Matthew Jones <jonespm at umich.edu> wrote:

> 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/760011d3/attachment.html