← Back to team overview

maria-discuss team mailing list archive

Re: Collations, trailing spaces and unique indexes


On 11.03.2016 10:30, Reindl Harald wrote:
> Am 11.03.2016 um 09:19 schrieb Binarus:
>> To make a long story short: I would like to have CHAR and VARCHAR fields with unique indexes which consider 'a' and 'a ' to be different values (which is the only reasonable point of view IMHO). This is not possible with MySQL. Is it possible with MariaDB?
> since MariaDB is supposed to be a drop-in-replacement a different behavior would be a bug and break existing applications

Not necessarily IMHO. If you could configure it (i.e. if you had to turn on such behaviour explicitly) then it wouldn't be a bug.