Subject RE: [ib-support] uppercase and double quotes
Author Jordi Gálvez
Nando,

> to me, it is exactly as designed/implemented/advertised.
> What is it exactly that you find wrong in the results?

I think I'm a bit confused, the statement created by IBExpert is:

CREATE TABLE "empleado" (
"dni" INTEGER NOT NULL,
"nombre" VARCHAR(50));

then I get error when:

select * from empleado

and works when:

select * from "empleado"


according to this, it seems that the quotes are part of the name, I mean
they are valid characters for the name of the table. If so, there should be
a difference between "empleado" with quotes and empleado without them. But
then, why at IBExpert when I enter the name empleado (whitout quotes) in the
table name field, then IBExpert generates a create table statement as

create table "empleado"

with quotes in the table name?

The question is, is the same a table name with quotes and without it? if
it's not, then I don't understand the IBExpert behaviour, but if it is, then
I don't understand why it gets me the error when I declare the table with
quotes and do the select without them.

Maybe I'm confused at some point? what is the real meaning of quotes at
table name?

Jordi