Обсуждение: case sensitivity

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

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.