Re: Trailing blanks get chopped away from 'strings'

[Michael Widenius]

>>>>> "Tobias" == Tobias Brox <tobiasb@stripped> writes:

>> According to the doc:
>> (...) All end space are removed when storing it. (...)

Tobias> So it's a feature, not a bug? This can hardly be compliant with the SQL
Tobias> standards? Well, at least it's better than the previous DBMS I used - it
Tobias> could only cope with 7-bit varchars...

Hi!

We regard this as a 'misfeature :)

(The problem is that we have some old code that depend on the above
behavour).

We intend to fix this in MySQL 4.0;  The new MyISAM can already handle
true varchars / We only have to update the upper layers in mysqld to
use the new functionality.

Regards,
Monty