Table and Field Name Capitalization

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 9 Apr 2003 09:42:38 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70388191D@lnewton.leeds.lfs.co.uk>

Morning,

I believe, although I'm not 100% sure, that the capitalisation of object names within the database is actaully an ANSI standard. I work with Oracle and Interbase/Firebird (to a lesser degree) and Interbase/Firebird was recently updated to comply with an ANSI standard which states (roughly) that any object name passed in double quotes must be processed without being upper cased. Anything not in double quotes should be upper cased internally. If SQLServer doesn't work to this standard, then I'm afraid it's SQLServer that is the 'wrong' system here.

Not much help I'm afraid :o(

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Wed Apr 09 2003 - 03:42:38 CDT