[Using Sakai] Charset encoding

[Matthew Jones]

Yea, I see that. :(

Unable to render {include} Couldn't find a page to include called: Sakai
CLE 2.x database
support<https://confluence.sakaiproject.org/pages/createpage.action?spaceKey=DOC&title=Sakai+CLE+2.x+database+support&linkCreation=true&fromPageId=75106757>

I updated the database support block for that page, not sure when it would
have stopped working. Seems like that old page was removed or renamed?

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

> 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"
>>>
>>
>>
>
> _______________________________________________
> 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/bb2e127f/attachment-0001.html