Ann W. Harrison wrote:

> tomconlon7777777 wrote:
>
>>It always intriged me how MSSQL, Sysbase, Watcom, etc had a single
>>setting to determine case-insensitivity across the entire DB.
>
>
> We considered that nearly 15 years ago and rejected it as too crude.
> For some fields case is important, for others not. We have lagged
> somewhat in providing case-insensitive collations, but I consider to
> think that case sensitivity is a field attribute not a database attribute.
>

Some fields need charset, others need OCTETS.
We have DEFAULT CHARACTER SET.

I don't understand why we can't have DEFAULT COLLATION.


Adriano