Jason Shao wrote:
On Aug 14, 2007, at 8:24 AM, Eric Dalquist wrote:
Would either of you be able to create a Jira issue detailing the
problem
so we can get this fixed for 2.6.1?
Thanks,
-Eric
Sherwin Shaidaee wrote:
I had the same problem, I had to change the table names to the
correct
case. It worked fine after that.
MySQL table-name case-sensitivity depends on the operating system
(filesystem really), but is something that seems to bite people a
lot, since a lot of people develop on Windows or Macs which have case-
insensitive file systems, but then deploy onto UNIX.
To solve this longterm, we probably need to either:
* beef up a developer style-guide that requires SQL to standardize on
either UPPER or lower case for table names (lowercase would be more
canonical MySQL)
* produce database configuration notes that recommend MySQL users on
Unix platforms set 'lower_case_table_names' in my.cnf [1] -- note
there are some conversion implications with this approach if you have
an existing database, but this is the recommended configuration for
InnoDB tables (which most people use to enable transaction support)
+1, for both items.
Thoughts?
Jason
[1] lower_case_table_names
--
Jason Shao
Application Developer
Rutgers University, Office of Instructional & Research Technology
v. 732-445-8726 | f. 732-445-5539 | [EMAIL PROTECTED] | http://
jay.shao.org
--
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
