Good point Adrian.  That is still the case with 5.

~Dave

On 5/11/07, Adrian J. Moreno <[EMAIL PROTECTED]> wrote:

IIRC, when using MySQL on Linux database names and database table names
(and aliases) are case sensitive since they're tied to the file system.
Databasse column names are not. I'm not sure if anything has changed as
of MySQL 5, but this was the case with versions 3 and 4.

i.e. Database table named "someTable":

"select a.ID from someTable A" would fail
"select a.ID from sometable a" would fail
"select a.ID from someTable a" works

-- Adrian

Dave Shuck wrote:
> Data sources are not case sensitive Chris.  I have never run across a
case
> sensitivity issue that didn't have some sort of file operation in the
mix.
>
> ~Dave

_______________________________________________
Reply to DFWCFUG:
  [email protected]
Subscribe/Unsubscribe:
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
    http://www.mail-archive.com/list%40list.dfwcfug.org/
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
  www.instantspot.com/
  www.teksystems.com/




--
~Dave Shuck
[EMAIL PROTECTED]
http://daveshuck.instantspot.com
_______________________________________________
Reply to DFWCFUG: 
  [email protected]
Subscribe/Unsubscribe: 
  http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: 
    http://www.mail-archive.com/list%40list.dfwcfug.org/             
  http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: 
  www.instantspot.com/
  www.teksystems.com/

Reply via email to