Re: Open issues for collations

Excerpts from Tom Lane's message of lun mar 28 21:02:40 -0300 2011:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > On lör, 2011-03-26 at 00:36 -0400, Tom Lane wrote:
> >> * It'd sure be nice if we had some nontrivial test cases that work in
> >> encodings besides UTF8. I'm still bothered that the committed patch
> >> failed to cover single-byte-encoding cases in upper/lower/initcap.
>
> > Well, how do we want to maintain these test cases without doing too much
> > duplication? It would be easy to run a small sed script over
> > collate.linux.utf8.sql to create, say, a latin1 version out of it.
>
> I tried. The upper/lower test cases require Turkish characters that
> aren't in Latin1. I'm not sure if we can readily produce test cases
> that cover both sorting changes and case-folding changes in just one
> single-byte encoding --- anybody?

ISO-8859-9?

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support