[Using Sakai] Charset encoding

[Nicolas Lupien]

Mattews, I've tryed the procedure in your link. Unfortunately, I'm having
lots of errors. I track down some of them : it stop when a field has a
foreign key. I tried to bypass those errors but theres just to much of them
preventing to the script to go trough.

Also, i've manually done this procedure for the User first and last name
fields and chars are now displayed as � which is not better.

I think this ends my journey of trying to fix database issues myself. The
choices I have are now living with it or restarting from scratch (but
considering our course is already live, this could be hard).

But thanks anyway for your help and thank you for fixing the database
support link. If you have any other idea you're welcome to let me know.

Nicolas Lupien



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

> 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/20111124/9e8a924f/attachment-0001.html