Re: Open issues for collations

Excerpts from Tom Lane's message of lun mar 28 21:02:40 -0300 2011:
> Peter Eisentraut <peter_e@gmx.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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support