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

> If national characters in identifiers and case sensitivity are so necessary
> for Swedish, I wonder how can you use Delphi ?
> Delphi is case insensitive, and can't use national characters
> in identifiers at all. In Firebird you have the choice of using (standard)
> delimited indentifiers to achieve case sensitivity.
>
> What would you do if you want e.g. persistent fields objects
> to be named according to database objects - is not it a mess
> to use national characters for database objects, and not for
> Pascal objects ?

Fact is I don't currently work with DB:s in that way. My Delphi project
uses Bold so all object data is stored in the Bold generated DB - I
don't really have to bother with the DB identifiers. Part of my
application runs SQL directly but that SQL is generated dynamically by
my application based upon object data so, again, the idetifier names
don't really matter in my Delphi code.

But you do have a point and I have had those exact troubles in other
projects. I don't know why, but I tend to find it easier to translate
the names in my Pascal code into English than the names in my DB:s. A
difference between DB:s and Pascal code is that in DB:s you usually have
complete control of your schema because you don't use third-party
"schema components". So you can choose your language without worrying
about ending up with a coctail of two or more languages. In Pascal code
you most certainly have to use names that others have created and they
are always (well...) in English. Therefore, it seems easier to use
English all through.

As a final point, I'd like to mention that in, say, ten years time, I
hope that support for national characters has spread to enough tools
etc. that it seems more natural to use the language best suited in each
particular situation, without having to worry about if it will work or
not. I think that's really my point. There have been some replies
stating that you don't want to be forced into anything whatsoever, and
without support for national characters everywhere, we are all *forced*
to use English. I hope that some day this will stop.

Kjell
p.s. I wouldn't complain if ObjectPascal/Delphi became case sensitive,
at least optionally per project
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64