Re: Territory based database: proposed change to current LIKE behavior vs = for character string types

[Daniel John Debrunner]

Bernt M. Johnsen wrote:

Does anyone know what MySQL, Oracle, SQL Server etc does with this? If
the other major databases are in agreement, we could follow their
interpretation if we find it reasonable.

MySQL has that LIKE and = can return different results.

See comments in DERBY-2967 and

http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html

Dan.