-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
smime.p7s
Description: S/MIME Cryptographic Signature
