CASE SENSITIVE - Issue (urgent)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vikkiatbipl - 22 Jan 2010 07:57 GMT

I am using Fedora 11 and MY SQL 5.1.32 version.

I have table as follows,

SupportData
------------------------------------------
SupportDataId int not null auto_increment
SupportData varchar(20)
------------------------------------------

> Select * from supportdata [ note: S and D are small in query]

It resulting table does not exist!
What is the reason?

Or shall i follow like this for table definition (ALL IN CAPS)

SUPPORTDATA
------------------------------------------
SUPPORTDATAID int not null auto_increment
SUPPORTDATA varchar(20)
------------------------------------------
Suggest me it is good practice ?

Thank you

VIKKI A

Reply to this Message

Paul Clement - 22 Jan 2010 15:39 GMT

¤ I am using Fedora 11 and MY SQL 5.1.32 version.
¤
¤ I have table as follows,
¤
¤ SupportData
¤ ------------------------------------------
¤ SupportDataId int not null auto_increment
¤ SupportData varchar(20)
¤ ------------------------------------------
¤
¤ > Select * from supportdata [ note: S and D are small in query]
¤ It resulting table does not exist!
¤ What is the reason?
¤
¤ Or shall i follow like this for table definition (ALL IN CAPS)
¤
¤ SUPPORTDATA
¤ ------------------------------------------
¤ SUPPORTDATAID int not null auto_increment
¤ SUPPORTDATA varchar(20)
¤ ------------------------------------------
¤ Suggest me it is good practice ?
¤
¤ Thank you
¤
¤ VIKKI A

First, I would change the column name in your table (Support data) so that it is different than the
table name. Unless you're running Unix table names are case insensitive.

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

VB Forum / Database Access / January 2010

CASE SENSITIVE - Issue (urgent)