The results from an SQL SELECT using "=" and "like" in the WHERE clause are different for MySQL and PostgreSQL, because MySQL behaves, by default, case insensitive and PostgreSQL case sentive. So for example in:

SELECT * FROM ezuser WHERE login = 'test';

MySQL returns all rows where login is equal 'Test' or 'test' or 'TEST' for example, but PostgreSQL returns only the row where login is equal 'test'.

A major problem here for example is that under PostgreSQL a user can register with a username that only differs in case from another one and what is worst a user can register more that once with the same email address if it differs in case.

Similar problems are extensible to other parts of ezp.

Thanks
Francisca Hernández