Geoff Worboys wrote:

>
> And notice the inconsistency here. In Firebird, obeying SQL
> rules, the name MYTABLE and "MYTABLE" are equivalent. In
> other systems (ones using lower case internally), also obeying
> the SQL rules, this would not work.

The SQL rules specify conversion to upper case, so systems like
Postgres and MySQL that fold to lower case are non-standard. This
may seem arbitrary and capricious, but it is logical and necessary
in many collations that include accented characters. In French
in France (though not in Canada), for example, upper case letters
do not carry accents. In that case, there is no reliable way to
down-case a word - you don't have enough information.

Best regards,


Ann