>> Surely one of these is unnecessary ?.
>Actually I think we need all four so the user/programmer can be
>explicit in her intentions and need not rely on a default that a server
>may or may not have implemented.
Absolutely. Some servers will have a default of case sensitive, some
will be case insensitive. This default should be included in the
explain record for the server, and the appropriate modifier can then be
used to change it.
Secondly it means that you can simply always include the modifier to be
sure that the server does the right thing, without checking the