Thread: case sensitivity

case sensitivity

From
"Peter T. Brown"
Date:
I've noticed that when creating databases, column names always end up in
lower case. Is there anyway to use mixed case column names?

Thanks



Re: case sensitivity

From
"Brett W. McCoy"
Date:
On Wed, 28 Feb 2001, Peter T. Brown wrote:

> I've noticed that when creating databases, column names always end up in
> lower case. Is there anyway to use mixed case column names?

Quote your column names when you create them:

create table mytable (
    "Id" integer primary key,
    "UserName" varchar(25)
);

You will also have to quote the names in query statements as well, IIRC.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
If you notice that a person is deceiving you, they must not be
deceiving you very well.