Jonas,
the problem is that you used double quotes within your create table
statement. If you'd used single quotes, the table name would have been case
insensitive. Most of us use single quotes and thus avoid any such problems.
By the way, using double quotes doesn't only affect case sensitivity, it
also makes it possible to use reserved words and spaces (I think). If you
want to confuse someone, you could try to create a table using e.g.

CREATE TABLE "SELECT"
(
"CHAR (4)" INTEGER NOT NULL,
CONSTRAINT "OR" PRIMARY KEY ("CHAR (4)")
);

I'm not 100% certain this would work, but think it is likely. Do you find
it strange that if you select from such a table, you have to use quotes - e.g.

SELECT "CHAR (4)"
FROM "SELECT"
WHERE "CHAR (4)" = 5

Set

At 09:18 25.02.2003 +0100, you wrote:

>Thanks for the help. I'm used to casesensitivess from mysql, but not
>used to programs that changes the case when you execute a query as
>IBOConsole did. Rather strange that you have to use "" to force the
>case, don't you think?