Mixed-Case Column Names ?

Posted in 1994

Billy Wheeler — 24 Nov 94 22:51:00 GMT — source: Informix-list mailing list archive (1991-1998)

To: timward@crl.com TEW> We are new to Informix, and I created some tables that had > column names containing a mix of upper and lower case alpha > characters. When I looked into the SYSCOLUMNS catalog table > afterwards, the column names showed up as ALL lower case. Yup. TEW> The manual says that an identifier (which includes column names) > can contain lower case AND upper case. Does Informix just ignore > the upper case? Is this an ANSI compliance thing? Yup. And yup. Informix is completely insensitive. Case-insensitive, that is.... TEW> Thanks. .... Tim. Don't mention it. Regards, billy.wheeler@digitec.co.za --- . SPEED 1.40 [NR] . But apart from that, Mrs Kennedy, how was the parade? ---- Digitec Online - South Africa Telnet: bbs.digitec.co.za or 196.11.62.106