On Wed, 14 Jul 2004, Joost Kraaijeveld wrote: > Is it possible to turn of the case sensitivity for tables and columns in > queries (to all CAPS)? I have a (closed source) tool that I have to use > (Clarion) that generates the queries and I cannot change the way the > tool generates the queries.
It's not currently possible to turn off case folding or to force spec complient upper case folding. You may want to look through the archives for the discussions if you wish to add something. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match