[Building Sakai] Strange issue with non latin-1 characters in text editor

[Chris Ribble]

Hi everyone,

We recently encountered an issue in our Sakai instance that has us 
scratching our heads. Not so much at the issue itself, but at the idea 
that we had not noticed it before. When editing a text based lesson in the 
Melete tool, composing a resource using the text editor or any use of the 
text editor(FCK Editor in our case), if you entered non latin-1 characters 
into the text editor, the next time you went to view your text the non 
latin-1 characters would become question marks. This caused a variety of 
formatting issues that seemed to go unnoticed for a while in our system. 
After much investigation we fixed it by changing the configuration of FCK 
Editor and using "FCKConfig.ProcessNumericEntities = true". 

I wanted to ask the community if anyone else had ran into this problem or 
whether anyone could shed some light on possible causes to this issue? Is 
it possible that we have the wrong character set in our database? 

Here is some additional information about our setup that might help:

Oracle 10g database with NLS_CHARACTERSET = 'WE8ISO8859P1',
Happens in both Sakai 2.7.1 and 2.5.2
Using FCKEditor 2.6.4.1


Thanks in advance,
Chris


Chris Ribble
LMS Application Developer
Information Technology Services
University of Windsor
519-253-3000 x4412
cribble at uwindsor.ca
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110803/1bb808fc/attachment.html