H.Merijn Brand wrote:
>
> Steffen Goeldner  wrote:
>
> >   SQL_IC_UPPER     = Identifiers in SQL are not case-sensitive and are
> >                      stored in uppercase in system catalog.
> >
> >   SQL_IC_LOWER     = Identifiers in SQL are not case-sensitive and are
> >                      stored in lowercase in system catalog.
> >
> >   SQL_IC_SENSITIVE = Identifiers in SQL are case-sensitive and are
> >                      stored in mixed case in system catalog.
> >
> >   SQL_IC_MIXED     = Identifiers in SQL are not case-sensitive and are
> >                      stored in mixed case in system catalog.
>
> Why do the people that invested this madness wanted to raise the suicide rate
> amongst DBA's?

I forgot to say that the characterization above applies to
`normal' identifiers (SQL_IDENTIFIER_CASE) and quoted identifiers
(SQL_QUOTED_IDENTIFIER_CASE) separately, e.g. for Oracle:

  SQL_IDENTIFIER_CASE         : SQL_IC_UPPER
  SQL_QUOTED_IDENTIFIER_CASE  : SQL_IC_SENSITIVE


Steffen

Reply via email to