RE: [Firebird-devel] UPPER does not work with national characters

[Peter J. <pj...@wa...>]

Hi Claudio, All,

> Yes, it's easy to default to a non-binary collation when a charset supports
> only one language. To give a western example, look at WIN1252 or ISO8859_1,
> what should be the non-binary default collation??? 

As I've already posted to firebird-devel, I'll prefer one of
two solution:

A) Default collation for every charset other than NONE
and OCTETS has:
A1) uppercasing conforming to default UNICODE tables
A2) sorting accoring to *UNICODE* codepoint order

A1 gives 99.98% correct behavoiur because having to
give a COLLATE clause
A2 gives consistent sorting behaviour across all character
sets

B) ("easy mode") 
B1) In addition to the existing behaviour (explicit CHARACTER
SET and COLLATE clauses), the datatype NCHAR is always
mapped to UNICODE UTF16BE and the data type is always mapped
to ISO-8859-x with x=1..16 configurable.
B2) Collation when no collation clause is given, is a configurable
<language>_<country> collation.
B3) Win32 (and maybe other) installers will set x and 
<language>_<country> according to the Regional Options found
on the system.

I'm aware that both solutions may have compatibility
problems to such a degree that they cannot be deployed,
but I wanted to state what I find desirable.

Regards,
Peter Jacobi