SELECT 'Müller' = 'Mueller'; do not return 1
Posted by: Timothy Chan
Date: March 02, 2011 08:09PM

I believe this has been discussed in the past but there has never been any real solution to it. I am trying to simulate the example below:

mysql> SELECT 'Müller' = 'Mueller';
+----------------------+
| 'Müller' = 'Mueller' |
+----------------------+
| 0 |
+----------------------+

mysql> SET collation_connection = latin1_german2_ci;

mysql> SELECT 'Müller' = 'Mueller';
+----------------------+
| 'Müller' = 'Mueller' |
+----------------------+
| 1 |
+----------------------+

But I am not getting as it supposed to although I have set the collation to latin1_german2_ci.

When I do a hex, I get the following:

mysql> select hex('Müller');
+---------------+
| hex('Müller') |
+---------------+
| 4D816C6C6572 |
+---------------+

mysql> select hex('Mueller');
+----------------+
| hex('Mueller') |
+----------------+
| 4D75656C6C6572 |
+----------------+

Any guru out there please help.

Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT 'Müller' = 'Mueller'; do not return 1
3357
March 02, 2011 08:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.