Subject Re: double single quote
Author Alexander V.Nevsky
--- In, "philc_pcm" <pcm@e...> wrote:
> Hi,
> Can someone explain me what is the rule in using single or double
> quotes?

In pre-IB6 versions and in dialect 1 since IB6 both are no more than
signs which limits chars, i.e. NAME='ALEXANDER' and NAME="ALEXANDER"
are both acceptable. In dialect 3 only single quotes can be used this
way, double are used in DDL to create case-sensitive object names
which can be reserved words. If you stepped on this way you always
should use this names in double quotes and exactly in the same case as
it was defined. Personally for me this is nightmare.

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

For SQL compliance. To be not used :)

Best regards,