From: Ann W. Harrison
Date: December 4 2008 4:16pm
Subject: Re: Please review fox for bug#34479
List-Archive: http://lists.mysql.com/falcon/254
Message-Id: <49380240.8030501@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT

Lars-Erik,
> 
> The trailing spaces (and minimum sort characters) I have been removing
> so far, I have converted to the given character set, so for f.eks UCS2,
> I have been looking to remove 0x0020, etc

Whatever the representation for spaces is, that's what we can safely
remove.  Everything else stays.
> 
> Should it be done like this for trailing zeros as well, so that I in the
> case of ucs2 should be looking to remove 0x0000?
> 

No - we remove trailings zeros on numeric keys only.  Happily they
don't have collations.


Cheers,

Ann