> From: bounce-12873496-15797...@lists.wisc.edu
> [mailto:bounce-12873496-15797...@lists.wisc.edu] On Behalf Of Moore, William
> (Joe)
> Sent: 22 December 2010 14:45
> To: uportal-dev@lists.ja-sig.org
> Subject: RE: [uportal-dev] converting all references
al-dev@lists.ja-sig.org
Subject: RE: [uportal-dev] converting all references to tables to uppercase
I can answer the question about MS SQL. We've been running in production for
several years.
* There are a few places where the SQL syntax for concatenation needs
to be changed in context fi
To: uportal-dev@lists.ja-sig.org
Subject: Re: [uportal-dev] converting all references to tables to uppercase
>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 ser
, 2010 10:53:14 PM
Subject: Re: [uportal-dev] converting all references to tables to uppercase
As far as I know it does.
As for consistent SQL case, it is probably doable in 2-3 days of searching
through code and testing. You'd have to be careful to really test layout
customization be
As far as I know it does.
As for consistent SQL case, it is probably doable in 2-3 days of
searching through code and testing. You'd have to be careful to really
test layout customization because all of that code is still using plain
old JDBC and so there are a lot of hand written SQL strings
>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
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
se
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