Subject Re: [firebird-support] Use of double quoted names in Firebird
Author Kjell Rilbe
Martijn Tonies wrote:

>>Why should SQL stay behind?
>
> Well... for one...
>
> In SQL Server, there was this system table INDEXES. It was
> defined as "indexes". Guess what happens on a server with a
> Turkish collation as the server wide collation?
>
> indexes uppercased becomes ÍNDEXES because the small
> character "i" becomes "Í" and not "I".
>
> Now, this means that every metadata name, although defined
> as "indexes" (no quotes, not case sensitive) might get messed
> up because of national crap.

On the other hand, since quoted identifiers are case sensitive, this
wouldn't be a problem.

:-)

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64