Leyne, Sean wrote:

> > It's not just a matter of differentiating between 16 bit words and
> > Unicode codepoints.
> >
> > For "DÄR" with Ä coded as A + diacritic composite ("DA¨R"), what exactly
> > does substring(MyDÄRstring, 3, 1) mean? Is it the diacritic '¨' or the
> > 'R'?
>
> Neither!
>
> Since SUBSTRING is a _string_ function, the correct answer would be "Ä"

Impossible, since the "A¨" combo starts at pos 2, and the substring call
requests extraction starting at pos 3. So the result has to be either
the diacritic "¨" if composites are treated just as ordinary codepoints,
or "R" if the "A¨" combo is treated as a single "character".

How do you propose the result should become "Ä"?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64