Subject | Re: [Firebird-Java] quotes in object names dialect 3 |
---|---|
Author | Helen Borrie |
Post date | 2003-12-30T10:31:53Z |
At 03:24 PM 21/12/2003 +0000, you wrote:
You *can* define tables, views and columns with double-quoted identifiers,
if you want them to be case-sensitive. You don't have to and, if you don't
define them with d/quotes, they will NOT be case-sensitive.
If you define them case-sensitive you have to use the d/quotes in every query.
Helen
>Hi,It's not a Java question!!
>
>tried to search archive but failed.
>
>one little question: may i not quote every name of an every table and
>view? maybe there is some property that prevents uppercaseing all my
>queries. all tables are named in lower case in my base.
You *can* define tables, views and columns with double-quoted identifiers,
if you want them to be case-sensitive. You don't have to and, if you don't
define them with d/quotes, they will NOT be case-sensitive.
If you define them case-sensitive you have to use the d/quotes in every query.
Helen