Re: Per-column collation

On mån, 2010-12-06 at 21:26 +0200, Peter Eisentraut wrote:
> 
> > * contrib/citext raises an encoding error when COLLATE is specified
> > even if it is the collation as same as the database default.
> > We might need some special treatment for C locale.
> > =# SHOW lc_collate;  ==> C
> > =# SELECT ('Ａ'::citext) = ('ａ'::citext);  ==> false
> > =# SELECT ('Ａ'::citext) = ('ａ'::citext) COLLATE "C";
> > ERROR:  invalid multibyte character for locale
> > HINT:  The server's LC_CTYPE locale is probably incompatible with
> the
> > database encoding.
> 
> OK, I can reproduce that.  That's fallout from the lc_ctype_is_c()
> optimization that I removed, as explained in another email.  I'll have
> to think about that again.

This is fixed in the 20101213 patch I'm about to send out.