[farcry-dev] Re: Case Sensitive table names

[Quentin Zervaas]

Title: Message

MySQL table names are represented by the operating system filename (for instance, the dmHTML table is represented the files dmHTML.frm dmHTML.MYD and dmHTML.MYI).. so in an OS with case-sensitive filenames (e.g. linux) you will also get case sensitive table names in your queries   my only guess for the reasoning of this is to make queries cheaper by not having check all the files in the database directory to see if their lowercase (uppercase) name corresponds to the lowercase (uppercase) table name in the query... it just tries to map the query's table name to the file system   we did a bit of work a little while back to try and make sure there are no inconsistencies in the MySQL queries in FarCry (that's also what my post earlier today was related to)....   Is the problem you're having from a query you're running manually, or is it generated from FarCry?   Cheers   --   Quentin Zervaas Web Developer   MITOUSA. Web + Interface Architects   T:// (08) 8361 9022 F:// (08) 8361 9977 E:// [EMAIL PROTECTED] W:// www.mitousa.com     ----- Original Message ----- From: Lucas Sherwood To: FarCry Developers Sent: Tuesday, November 18, 2003 4:27 PM Subject: [farcry-dev] Case Sensitive table names hey guys, just been playing with a farcry implementation with mysql and i am seeing some weirdness with table names  has anyone seen case sensitive table names in mysql??   L.   -- Lucas Sherwood Evangelist - Server Products Macromedia EMEA   +44 7881 803 170 [EMAIL PROTECTED]   -- Learn more about MAX 2003: MAX site: http://www.macromedia.com/go/max/ Questions: [EMAIL PROTECTED] -- This e-mail and any attachments may contain confidential information that is legally privileged. If you are not the intended recipient, any use, copying or transmission of this information is strictly prohibited.  If you received this email in error, please delete all copies and notify us immediately.     --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004