Subject Re: [firebird-support] double single quote
Author Helen Borrie
At 04:58 PM 17/03/2004 +0000, you wrote:
>Can someone explain me what is the rule in using single or double
>It seems that double quote works if you use it in a field or table
>name but doesn't work in where clause for values. And the Single
>quote is the opposite.

This is the correct situation. Or, to put it another way, double quotes
are not used for anything except delimiting case-sensitive identifiers (and
then you're well-advised to avoid case-sensitive identifiers unless you
actually MUST have them).

>I'm just curious if this is done on purpose for SQL compliance or just
>a current limitation.

It's done on purpose for SQL standards compliance.

>I came across this problem when converted some old simple SQLS that
>worked in Oracle (which supports just about everything including
>apples and bananas) and now doesn't work in Firebird.

Not surprising.