[Using Sakai] Short URLs for files with non ASCII characters

[Steve Swinsburg]

Go to the database and see what the full url is for this shortened URL. Does it match the actual resource URL? 

Cheers,
Steve

Sent from my iPad

On 17/08/2013, at 7:23, Rafael Morales Gamboa <rmorales at suv.udg.mx> wrote:

> Actually, I was wrong. Tomcat is configured with URIEncoding="UTF-8" and the database seems to be OK (despite de fact that there is no character_set_server=utf8 in my.conf:
> 
> mysql> SELECT default_character_set_name FROM information_schema.SCHEMATA S
>     -> WHERE schema_name = "sakai";
> +----------------------------+
> | default_character_set_name |
> +----------------------------+
> | utf8                       |
> +----------------------------+
> 1 row in set (0.00 sec)
> 
> The question is whether I should add that configuration line to my.conf, anayway.
> 
> Regards,
> Rafael
> 
> El 15/08/2013 06:50 p.m., Mike DeSimone escribió:
>> Hi Rafael,
>> 
>> Sometimes things like this are due to database settings and tomcat connector settings.  Can you confirm the 8080 connector has URIEncoding="UTF-8"?  Also, if this is MySQL, then ensure this is in the my.cnf: character_set_server=utf8 and the database was created with utf8 encoding.
>> 
>> more info can be found here: https://confluence.sakaiproject.org/display/DOC/Sakai+CLE+2.9+Release+Notes#SakaiCLE29releasenotes-Databasesupport
>> and: https://confluence.sakaiproject.org/pages/viewpage.action?pageId=82249313 (section 3 for tomcat setup)
>> 
>> I also have found that files cannot easily be renamed in the Sakai UI.  Not sure if there's any other solution than your suggestion.
>> 
>> 
>> Thanks,
>> 
>> *********************************************
>> Mike DeSimone
>> Director of Enterprise Operations
>> Asahi Net International, Inc. (ANI)
>> O: +1 (602) 490-0473
>> W: anisakai.com
>> 
>> 
>> **********************************************
>> 
>> 
>> On Wed, Aug 14, 2013 at 4:25 PM, Rafael Morales Gamboa <rmorales at suv.udg.mx> wrote:
>> Hello,
>> 
>> On Sakai 2.9.1 I uploaded a file to Resources that was called 'Introducción a Sakai - Perspectiva del Usuario.pdf' in my computer, and I renamed it to 'Introducción a Sakai.pdf' in Resources and made it public. Under properties I can see now its URL:
>> 
>> http://virtual.cudi.edu.mx:8080/access/content/group/8bf73c8c-0968-4914-8c44-918d76fa3896/Introducci%C3%B3n%20a%20Sakai%20-%20Perspectiva%20del%20Usuario.pdf
>> 
>> So, the URL is composed from the original name of the file in my computer, and I cannot see a way to change it unless renaming the file in my computer before uploading it to Resources.
>> 
>> Now, if I choose the Short URL option I get the URL http://virtual.cudi.edu.mx:8080/x/HaqXOC, and at least three distinct behaviours in browser (latest public releases of them):
>> In Firefox, I get error 404.
>> In Chrome, it is translated to http://virtual.cudi.edu.mx:8080/access/content/group/8bf73c8c-0968-4914-8c44-918d76fa3896/Introducci%F3n%20a%20Sakai%20-%20Perspectiva%20del%20Usuario.pdf ('ó' is encoded as %F3 instead of %C%B3) and I get error 404.
>> In Internet Explorer it works! ('ó' is just 'ó').
>> The questions are (1) why do I get all this different behaviours? and (2) how can I get it to work on all these browsers?
>> Regards,
>> Rafael
>> 
>> 
>> _______________________________________________
>> 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/20130818/e1d0298c/attachment.html