Subject Re: Firebird and ODBC
Author Michael Vilhelmsen
Hi Fidel

Thx for the information.
I will give it on to the developer of the program.

But basically I dont care how they do in MS SQL.
I care about Firebird.

This doesn't mean at all that I dont care about what you have helped
me with.
It actually made some discussion easier from my point of view.

Thanks again

Michael

--- In firebird-support@yahoogroups.com, "Fidel Viegas"
<fidel.viegas@...> wrote:
>
> On Feb 6, 2008 9:50 AM, Fidel Viegas <fidel.viegas@...> wrote:
>
> > In MS SQL Server, you replace the "" with [ and ]
>
> I forgot to mention that MS SQL also supports "". That has to do with
> the QUOTED_IDENTIFIER option. I don't really remember as I haven't
> really worked that much with SQL Server. I know that it does support
> both "" and []. If QUOTED_IDENTIFIER is on, then you use "", if it is
> OFF, then you use []. There is one thing you have to remember though.
> If you set QUOTED_IDENTIFIER to on, then it will work similar to
> Firebird. That is, you use "identifier name" for identifiers and 'text
> value' for text. If you set it to OFF, then you use [identifier name]
> for identifiers and "text value" for text.
>
> Just to make sure, have a look at the user manuals.
>
> All the best,
>
> Fidel.
>