Subject Re: [firebird-support] Re: Upper case behaviour
Author Ann W. Harrison
Adam wrote:
>
> I think we are complicating the issue beyond what the OP is asking
> for. All Firebird really needs to do to support such a feature is add
> a few fields in the various system tables to store the text as declared
>
> eg. RDB$RELATIONS.RDB$RELATION_NAME can have a sister field
> RDB$RELATIONS.RDB$RELATION_DISPLAYNAME
>
> The case sensitivity, delimiter rules and stored field names remain
> unchanged, but third party tools (as well as Show Tables etc) can
> report the display name.
>

Actually, there's already RDB$QUERY_NAME which was designed for that
purpose, and could be used for that purpose, I guess.

The problem is that existing tools depend on their ability to quote
names as they appear in SHOW statements. Breaking them isn't going
to improve the world.


Best regards,

Ann