Thanks SET, its all clear now !

Sorry for putting my message in reply .

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær
Sent: Tuesday, February 14, 2006 2:25 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Index with lower case

First of all, never start a new thread by choosing reply to an old
message (whether or not you delete the old message). Some members on
this list use threading and abusing the reply button cause their
threads to be more difficult to read (and if you reply to a message
that is not of interest to them, they're unlikely to ever see your
message).

> Index definition for lower case:
> ALTER TABLE "sys_company" ADD CONSTRAINT "pk_sys_company" PRIMARY KEY
> ("com_id");

> Index definition for upper case
> ALTER TABLE SYSCOM ADD CONSTRAINT PK_SYSCOM PRIMARY KEY (COMNUM);

> I wonder why for lower case I have "" for names ?????

By default Firebird use case insensitive table and field names, and
store them in upper case. Hence, sys_company, Sys_Company and
SYS_COMPANY are all identical. You can make them case sensitive by
putting them in double quotes, and hence "sys_company" isn't equal to
any of the three names above (not even sys_company). However, case
sensitive indexes all uppercased are stored and treated the same way
as case insensitive indexes. So, "SYS_COMPANY" is identical to
sys_company, but both of these are different to "sys_company".
Confused yet?

HTH,
Set





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links