Something strange with lowercase/uppercase, using double quotes for creating
table names and dialect 3 databases.

The table empleado is declared as:

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

/* Primary keys definition */

ALTER TABLE "empleado" ADD CONSTRAINT PK_EMPLEADO PRIMARY KEY ("dni");



It was created exporting the table from MSAccess with Gemini ODBC driver (v2
beta)

Within IBExpert I have tried to do simple selects:

select * from EMPLEADO => ERROR!
select * from empleado => ERROR!
select * from "EMPLEADo" => ERROR!
select * from "EMPLEADO" => ERROR!
select * from "empleado" => WORKS!


But if database objects are declared without double quotes:

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

/* Primary keys definition */

ALTER TABLE empleado ADD CONSTRAINT PK_EMPLEADO PRIMARY KEY (dni);

We get these results:

select * from EMPLEADO => WORKS!
select * from empleado => WORKS!
select * from "EMPLEADo" => ERROR!
select * from "EMPLEADO" => WORKS!
select * from "empleado" => ERROR!

What happens? is it an Interbase bug or the problem is in IBExpert or maybe
the Gemini ODBC?


Jordi Gálvez

- Catalan Institute of Oncology -