Subject Re: [firebird-support] Re: Upper case behaviour
Author Martijn Tonies
> 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.

Wrong. When reporting only the display name, the user has no way
of knowing if the name is case sensitive or just case preserving :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com