Is systables.tabname case sensitive?
Low Kit Ming asked whether systables.tabname is case-sensitive, since a WHERE match on LPAtable found no row but lpatable did. Christophe MAUMONT, Prounix GmbH, Helmut Leininger and Jonathan Stowe all confirmed that WHERE comparisons are case-sensitive. Prounix suggested upper(tabname) = upper("lpatable"); Leininger noted table names are stored in lowercase in non-ANSI databases. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Greeting... Is systables.tabname column case-sensitive? What is the different between these two sql statement: A) select 1 from systables where tabname="LPAtable" ==> no row found B) select 1 from systables where tabname="lpatable" ==> one row returned Thanks kit
Select clause "where tabname = 'xxxx'" is case sensitive. Low Kit Ming <kmlow72@hotmail.com> a 'crit dans le message : 38169282.2524F73E@hotmail.com... > Greeting... > > Is systables.tabname column case-sensitive? > > What is the different between these two sql statement: > A) select 1 from systables where tabname="LPAtable" ==> no row found > B) select 1 from systables where tabname="lpatable" ==> one row > returned > > Thanks > kit >
YES, all select statements are case-sensitive. But you can use the buildin function "upper" (where upper(tabname) = upper("lpatable") Low Kit Ming wrote: > Greeting... > > Is systables.tabname column case-sensitive? > > What is the different between these two sql statement: > A) select 1 from systables where tabname="LPAtable" ==> no row found > B) select 1 from systables where tabname="lpatable" ==> one row > returned > > Thanks > kit --
Low Kit Ming wrote: > Greeting... > > Is systables.tabname column case-sensitive? > > What is the different between these two sql statement: > A) select 1 from systables where tabname="LPAtable" ==> no row found > B) select 1 from systables where tabname="lpatable" ==> one row > returned > > Thanks > kit Hi, I think you are mixing up two facts: 1) table names are not case sensitive, at least if the database is not ansi compliant. The table names are stored in lowercase. 2) the select statement (WHERE clause) is case sensitive Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.
Low Kit Ming <kmlow72@hotmail.com> wrote: > Greeting... > > Is systables.tabname column case-sensitive? > > What is the different between these two sql statement: > A) select 1 from systables where tabname="LPAtable" ==> no row found > B) select 1 from systables where tabname="lpatable" ==> one row > Yes. The statement will match whatever is in tabname - a criterion of '=' is always case sensitive regardless of what table you are querying. /J\\ -- "It's times like this I wish I had a penis" - Duckman