Question about column name case sensitive

[Ying Lu]

Hello,
I have a question about column name case sensitive. Currently, we use 
MySQL 3.23.32 running on Linux.

I am trying to use JDBC to get email from table T1
T1(
    id char(3),
    name varchar(12),
    Email    varchar(16)
)
Now If I say,
   try{
   ...
      String email = 
getString("email");                                          //here I 
got Exception saying "Column name cannot be found"
    ...
   }catch(Exception e){

      System.err.println(e);
   }
If I change the exception line to
    getString("Email");
everyting is all right.
In  MySQL documentation, on all OS, there should not have column name 
case sensitive problem, right? But how come I changed the column name to 
the same format as saved in table T1 it works; otherwise, I got exception?

Thanks a lot!
Emi


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]