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]