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.