Subject Re: [firebird-support] dialect 3 field names.
Author Milan Babuskov
Mitchell Peek wrote:
> How can one determine, form the system tables, if a column name was
> declared with Dialect 3 syntax. in other words,
> Create table ATable (
> Quantity BigInt,
> "Quality" SmallInt )
> If I join rdb$relations, rdb$relation_fields, and rdb$fields, I can get
> almost everything I need, but not whether or not the field requires case
> sensitivity. Am I just overlooking it?

It's really simple. If field has any lower-case characters, then it's name is
case sensitive.

Milan Babuskov