johnson_dave2003 wrote:

>
>
> In german, the character 'ß' (esstet) is absolutely equivalent
> to 'ss'. So, 'Fußball' and 'Fussball' should be seen as equal. The
> uppercase rule for 'ß' is that it becomes 'SS', so uppercase
> ('fußball') = 'FUSSBALL'
>

Fascinating. So, this query would return both these results:

select name from sports where name = 'Fußball'

Fußball
Fussball

What is the correct handling strlen and the character 'ß' - is it one or
two? And the result of this query?


select name from sports
where name = 'Fußball'
and strlen (name) = strlen ('Fußball')
and substring (name from 3 for 1) =
substring ('Fußball' from 3 for 1)


And then, how are double letters that collate as a single letter ('ll'
in Spanish) handled in strlen and substring? And, in collations that
don't accent upper case letters is is OK that lower(upper('à') <> 'à'?

Cheers,

Ann