>From reading the MySQL manual, it says we'd need to adjust every other >database and table as well. And apparently many other systems use this same >database server.
"If you plan to set the lower_case_table_names system variable to 1 on Unix, you must first convert your old database and table names to lowercase before stopping mysqld and restarting it with the new variable setting." I've raised this with the db admins but it's not something they want to do. This is unfortunate, since a case insensitive setup is best practice for this exact reason. I'm pursuing alternatives. Does uPortal run ok on SQL Server? thanks, Steve On 22/12/2010, at 2:45 PM, Eric Dalquist wrote: > Can you simply flip the MySQL flag to disable case sensitivity (and make it > actually SQL compliant in the process :p)? I think it is documented in the > manual. > > -Eric > > On 12/21/10 9:12 PM, Steve Swinsburg wrote: >> Hi all, >> >> We have a situation where our MySQL cluster has been configured as case >> sensitive. Thus, the uPortal tables are all uppercase, but several places >> references these tables as lowercase (looks like the crns and probably some >> hand written SQL), which is obviously failing. >> >> Does anyone have any idea how much effort would be required to convert the >> references to the tables to be all uppercase? I think that converting >> everything in our systems to lowercase would be a massive task, considering >> we have many existing databases and applications on this cluster already. >> >> Converting it all to uppercase should work, but it does mean that people >> need to be vigilant when writing SQL by hand so as to ensure all uppercase. >> Alternatively, convert all of the table creation SQL to produce lowercase >> table names. >> >> Thoughts? >> >> thanks, >> Steve > -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
