[Building Sakai] A Sensitive Subject

[Steve Swinsburg]

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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121015/48fc9ae0/attachment.html