I believe that MySQL will let you use any case for any entity (caveat to come), as long as you're consistent through out a single query for each entity. So you can differ the case across multiple queries, but within a single query, every reference has to be cased the same. In addition, table names, because they directly correspond to files on the filesystem, are as case sensitive as your file system, subject to the option described on the page Jochem linked to.
Of course, I could be somewhat off base (and Jochem will surely correct me), but I stick to my casing rules, so I generally don't have to care. cheers, barneyb On Wed, 9 Feb 2005 14:26:32 -0500, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > MySQL uses case-sensitive entity names? OUCH! I thought case-sensitive > _INDEXES_ were difficult to work with. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
