Hello,
bug or feature ?
* PETER in uppercase :
sql>CREATE TABLE "PETER" ( nom varchar(20) );
operation successful (2.545ms)
sql>DROP TABLE PETER;
DROP TABLE: no such table 'peter'
sql>DROP TABLE "PETER";
operation successful (1.947ms)
* peter in lowercase :
sql>CREATE TABLE "peter" ( nom varchar(20) );
operation successful (2.917ms)
sql>DROP TABLE peter;
operation successful (1.882ms)
* peter in lowercase and uppercase :
sql>CREATE TABLE "peter" ( nom varchar(20) );
operation successful (2.900ms)
sql>CREATE TABLE PETER ( nom varchar(20) );
CREATE TABLE: name 'peter' already in use
sql>CREATE TABLE "PETER" ( nom varchar(20) );
operation successful (9.339ms)
Conclusion :
PETER is convert in peter
"PETER" is not convert
Pierre Coustillas
--
1G6
52 route de bischwiller
67300 Schiltigheim
Société de Services et de Formations en Logiciels Libres
http://1g6.biz
Tél : 06 64 63 70 35 // 09 54 38 70 90