Subject Re[2]: [ib-support] Why the table name & column name must with double quote?
Author Daniel Rail
Hi,

At May 29, 2003, 22:55, Helen Borrie wrote:

> The reason is that you have used the option to create database objects with
> quoted identifiers - an option that is available to allow you to use
> identifiers that contain spaces, or that need to be case-sensitive, or that
> are the same word as a reserved word. IBManager might have decided to do
> it this way automatically, if it detected that your legacy database had
> such identifiers in place.

Actually, it's in the Database Registration Info in IBManager.
There's a check box on the bottom(at least with QuickDesk 2.9) that
indicates is you want to always capitalize database objects names. If
you don't select this option by placing a checkmark, then the database
objects will be created with case sensitive names. I learned this the
hard way a few years back. By default, it's unchecked and you can't
change that default in the settings, at least with version 2.9(maybe
it's possible for 3.0).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)