Re: case sensitivity issue

[Werner Stürenburg]

> I'm having trouble with what appears to be a case sensitivity issue.
> Essentially, when I use the "right" case for a table name, the query fails,
> but when I use the wrong case, the query succeeds.

Well, it seems to depend on the system you are using. I noticed
that when I created tables through phpMyAdmin on my local Win
system, that the table(=file) was created on disk lower case only.

It doesn't matter on Win, as the file system is not case
sensitive, but it does on Linux. So you have to be careful if you
transfer tables.

I didn't see the create table syntax make any mistakes, so I
think it is phpMyAdmin, but I don't know - I didn't care to
check.

Check the tablename(=filename) and rename the table or change the
name in your scripts.


-- 
Herzlich
Werner Stürenburg

_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

case sensitivity issue

[Alex Pukinskis]

I'm having trouble with what appears to be a case sensitivity issue.
Essentially, when I use the "right" case for a table name, the query fails,
but when I use the wrong case, the query succeeds.

Here's my table list:

mysql> show tables\g
++
| Tables_in_ac   |
++
| Employee   |
| PerfAssessment |
| PerfReview |
| Workgroup  |
++
4 rows in set (0.00 sec)

So it seems like the table is called "Employee", but this query fails:

mysql> SELECT Email, FirstName, LastName FROM Employee WHERE ID = 3\g
Empty set (0.00 sec)

However, when I use the wrong case for the table name ("employee"), it
works:

mysql> SELECT Email, FirstName, LastName FROM employee WHERE ID = 3\g
+-+---+--+
| Email   | FirstName | LastName |
+-+---+--+
| [EMAIL PROTECTED] | Jack  | Smith|
+-+---+--+
1 row in set (0.00 sec)

The same results happen if I do SELECT * instead of specifying columns.

My workaround is to call the table "employee" in my scripts, but this is
extremely puzzling.  Does anyone have any ideas?  I've included my system
information below.

Thanks,

-Alex


Release:   mysql-3.23.39 (Source distribution)
System: Darwin ermine 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun  9 11:12:48
PD\
T 2001; root:xnu/xnu-124.13.obj~1/RELEASE_PPC  Power Macintosh powerpc
Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/cc
Compilation info: CC='cc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC:
lrwxr-xr-x  1 root  wheel  15 Jul 17 14:47 /usr/lib/libc.dylib ->
libSystem.dyl\
ib
Configure command: ./configure  --prefix=/usr/local/mysql


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php