Peter Kellner (pe***@peterkel lner.net) wrote:
: This followup was posted to mailing.databas e.mysql
: In article <42******@news. victoria.tc.ca> ,
yf***@vtn1.vict oria.tc.ca
: says...
: > Peter Kellner (pe***@peterkel lner.net) wrote:
: > : I notice that on unix the default for case sensative is off which means
: > : tables created with upper case need to be referenced in sql as upper
: > : case. It seems that if the case sensative variable is set to 1, then
: > : select emp works as well as select EMP. Is there any reason not to set
: > : it to 1? Also, is there an ansi standard for this? I could not find a
: > : reference to one.
: >
: > Are you talking about "lower_case_tab le_names"?
: >
: Sorry for not being more clear. You assumed correctly what I was
: looking for. I'm inclined to change the setting to force lowercase,
: however since this is not the default behavior it makes me nervous to
: change it.
I have no experience to share on this.
My guess is that if you use this setting from day 0 of your database then
you won't have a problem. Every item for which this would make a
difference will be forced to use lowercase.
If you then turned off the setting then you could still access everything
by writing your queries in lowercase.
That's my reading of it, but it's not based on experience.
--
This space not for rent.