|Subject||RE: [firebird-support] system tables - second attempt.|
|Author||Svend Meyland Nicolaisen|
> -----Original Message-----I suspect that all field names basically are treated as case sensitive by
> From: email@example.com
> [mailto:firstname.lastname@example.org] On Behalf Of Martijn Tonies
> Sent: 15. april 2005 18:41
> To: email@example.com
> Subject: Re: [firebird-support] system tables - second attempt.
> > >> which brings the question how do you tell between a
> column defined
> > >> as "SOMEFIELD" and a column defined as SOMEFIELD?
> > MT> Try creating such a table and you'll know :-)
> > good idea. :-)
> > It appears that if you delimit an all-uppercase identifier
> the engine
> > behaves as if you didn't, i.e. you can refer to it in lower
> or mixed
> > case without quotes. I don't know whether that's documented
> > or not; I didn't know it for sure.
> As far as I know, it is. All uppercase equals no quotes.
> Unless you've used a keyword, of course.
the FireBird engine. However when not using quotes the field name is
converted to all upper case before it is "handed" to the FireBird engine.
This makes it look like that the engine isn't case sensitive. I haven't
looked at the code though so maybe I'm wrong.....