Thx. That answered my question.
karam --- Mark Leith <[EMAIL PROTECTED]> wrote: > Hi Karam, > > I'm not sure what you mean by "All the tables, > columns and values are given > in CAPS lock.".. > > Certainly, all of the INFORMATION_SCHEMA tables and > their columns are > defined in upper case. This probably won't change.. > However, any "values" > are stored in the case that they were created in. > For example, if you > created a table in test called "foo", and were to > "SELECT table_name FROM > INFORMATION_SCHEMA.TABLES WHERE table_schema = > 'test';" it would return > "foo" - not "FOO". > > HTH > > Mark > > Mark Leith > Cool-Tools UK Limited > http://www.cool-tools.co.uk > http://leithal.cool-tools.co.uk > > > > -----Original Message----- > > From: Karam Chand [mailto:[EMAIL PROTECTED] > > > Sent: 10 August 2005 15:26 > > To: mysql@lists.mysql.com > > Subject: [SPAM?]: Case issue in Information_schema > > > > Hello, > > > > I was just checking INFORMATION_SCHEMA in 5.0.10. > All the > > tables, columns and values are given in CAPS lock. > > > > The case is not important in Windows but it is in > Linux. > > > > Do I assume that even in Linux it will be in CAPS > and the > > case is not going to change in near future? > > > > Karam > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.338 / Virus Database: 267.10.5/67 - > Release Date: 09/08/2005 > > > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]