[Building Sakai] A Sensitive Subject

[Steve Swinsburg]

Nowhere is it stated that the case of SQL needs to be maintained. 
It is true that if you are running a case sensitive database then you might have issues, which is why its recommended not to run a case sensitive database. 

https://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning

Also, have a look at the chat2_channel table for some mixed case mayhem.

cheers,
Steve

On 15/10/2012, at 6:09 PM, Stephen Marquard <stephen.marquard at uct.ac.za> wrote:

> I have to disagree with that ("there is no standard case enforced").
> Sites running databases with case-sensitive table names (as we are)
> would take a dim view of any changes checked in that referred to
> existing tables with different case, as it basically would not work.
> Developers are required to use the same case for table names as the
> table names were set up with (in the DDL SQL or hibernate config).
> 
> Cheers
> Stephen
> 
> Stephen Marquard, Learning Technologies Co-ordinator
> Centre for Educational Technology, University of Cape Town
> http://www.cet.uct.ac.za
> Email/IM/XMPP: stephen.marquard at uct.ac.za
> Phone: +27-21-650-5037 Cell: +27-83-500-5290
> 
> 
>>>> Steve Swinsburg <steve.swinsburg at gmail.com> 10/15/2012 1:18 AM >>>
> And there is no standard case enforced when referring to the same
> tables or
> columns, ie SAKAI_USER, sakai_user for example.
> 
> Bottom line, set your db up to be case insensitive.
> 
> cheers,
> Steve
> 
> On Mon, Oct 15, 2012 at 3:44 AM, David Horwitz
> <david.horwitz at uct.ac.za>wrote:
> 
>> One way of putting is:
>> 
>> "Sakai does not require case sensitive table names but all scripts
> and
>> code should assume that it may be running on a database that is case
>> sensitive"
>> 
>> D
>> 
>> 
>> 
>> On 10/12/2012 04:04 PM, Matthew Jones wrote:
>> 
>> If you're running Mysql on Non-OSX UNIX, then by default the table
> names
>> are case sensitive.
>> 
>> In the admin guide we recommend altering the Mysql configuration so
> it
>> isn't case sensitive which is the default value for OSX and Windows
> (
>> 
> https://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning)
>> but it should work either way. All hard coded queries, conversion
> scripts
>> as well as Mysql QA servers are set to be case sensitive
>> 
>> On Fri, Oct 12, 2012 at 9:56 AM, Mark J. Norton
> <markjnorton at earthlink.net
>>> wrote:
>> 
>>> Does Sakai require database table names to be case sensitive?  I
> don't
>>> seem to recall anything about this in the database set-up of the
> install
>>> instructions.
>>> 
>>> - Mark Norton
>>> 
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>> 
>>> TO UNSUBSCRIBE: send email to
>>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>>> 
>> 
>> 
>> 
>> _______________________________________________
>> sakai-dev mailing
> listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
>> 
>> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>> 
>> 
>> 
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> 
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>> 
> 
> 
> 
> 
> ###
> 
> UNIVERSITY OF CAPE TOWN
> 
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
> +27 21 650 9111. This e-mail is intended only for the person(s) to whom
> it is addressed. If the e-mail has reached you in error, please notify
> the author. If you are not the intended recipient of the e-mail you may
> not use, disclose, copy, redirect or print the content. If this e-mail
> is not related to the business of UCT it is sent by the sender in the
> sender's individual capacity.
> 
> ###
> 
> ________________________________
> UNIVERSITY OF CAPE TOWN
> 
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 9111. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
>