Migration from MySQL 3.23.58 to MySQL 5 - problem with unique keys

[Henrik Basten]

Hi everybody,

I have an old MySQL 3.23.58 database which I want to migrate to the latest MySQL version.
I have done some tests and can see that I will have a problem with some unique keys:
In MySQL 3 it was allowed to have blanks at the beginning and the end of a unique key. This means that both entries "string" and " string " where possible.
Now it seems that MySQL 5 is always trimming the values of unique key, so that I will get a duplicate key if I try to enter both values.

Is there a configuration setting which makes MySQL 5 act like MySQL 3. Or are there any other suggestions how to handle this?

Thanks alot!
Henrik