• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Weird mysql problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Weird mysql problem


  • Subject: Re: Weird mysql problem
  • From: "Cheong Hee (Gmail)" <email@hidden>
  • Date: Mon, 6 Sep 2010 12:17:50 +0800


My take is setting to lower case table is no.1 item to avoid issues later.  Workbench sometimes couldn't generate values properly in my cases, view and edit my.cnf whenever necessary.
I now have this in my /etc/my.cnf:

lower_case_table_names = 1

MySQL says this: "1: Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases."
(http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html)

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >Weird mysql problem (From: Mark Woollard <email@hidden>)
 >Re: Weird mysql problem (From: Paul D Yu <email@hidden>)
 >Re: Weird mysql problem (From: Klaus Berkling <email@hidden>)

  • Prev by Date: Re: Weird mysql problem
  • Next by Date: [ANN] Safari Extension 0.90
  • Previous by thread: Re: Weird mysql problem
  • Next by thread: [ANN] Safari Extension 0.90
  • Index(es):
    • Date
    • Thread