Case Sensitivity

Breako · #1 (**permalink**) 03-09-09, 13:38

Hi,
1. Is DB2 case sensitive or insensitive by default?
2. Obviously, I can check this my running a few simple queries, but I was just wondering is there a Session property that I can check?
Thanks.

Marcus_A · #2 (**permalink**) 03-09-09, 14:58

The data is case sensitive. The DLL object names are converted to Upper Case unless you put quotes around the object name in lower case, in which case (no pun intended) you will probably be lynched by a mob of angry DBA's or developers.

stolze · #3 (**permalink**) 03-10-09, 04:56

SQL is case sensitive for string values and comparing them. DB2 follows the SQL standard in this respect. Identifiers for schema, table, or columns names (aka object names) are not string values, though.

Internet Services

Web Development

Digital Marketing

Consumer Tech