Dear List, Is there a way to completely turn off case sensitivity of the names of table, field, sequence, etc.?
In our case we used mixed-case names, and the names are unique. They wouldn't collide even if they get turned into lowercase names. Because of interfacing problems with other softwares, I wish to make all names case insensitive. However we already have some scripts using case sensitive names, so don't want just to convert the database to lowercase only. This is why I am looking to turn off case sensitivity of the database as a whole. (So that "MyTable", mytable, MyTable will all work.) I would appreciate any advice. Regards, Ben ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend