latin1_german2_ci

[Wagner Bianchi]

Hi friends,

I´ve some problems for simulate a exemplo by the guide of certification for MySQL 5. I've try to return 1 for this comparison:

mysql> SELECT 'Müller' = 'Mueller';

...the answer i've received by the server id ever 0...and i ask, why?

In the sequece, my log tests:

###################################################################

In 6.0.2

mysql> SELECT 'MÜLLER' = 'MUELLER';
+----------------------+
| 'MÜLLER' = 'MUELLER' |
+----------------------+
| 0 |
+----------------------+
1 row in set (0.00 sec)

mysql> select @@collation_connection;
+------------------------+
| @@collation_connection |
+------------------------+
| latin1_german2_ci |
+------------------------+
1 row in set (0.00 sec)

mysql> set collation_connection =latin1_german1_ci;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT 'MÜLLER' = 'MUELLER';
+----------------------+
| 'MÜLLER' = 'MUELLER' |
+----------------------+
| 0 |
+----------------------+
1 row in set (0.00 sec)

(in the midle of thi log, i tried to chnge for german1 for change or force result)

###################################################################

In 5.0.18

mysql> SET @str1 = 'Hühner-Hugos Hähchen sind schön.';
Query OK, 0 rows affected (0.00 sec)

mysql> SET @str2 = 'Huehner-Hugos Haehchen sind schoen.';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @str1 = @str2;
+---------------+
| @str1 = @str2 |
+---------------+
| 0 |
+---------------+
1 row in set (0.00 sec)

mysql> select @@collation_connection;
+------------------------+
| @@collation_connection |
+------------------------+
| latin1_german2_ci |
+------------------------+
1 row in set (0.00 sec)

###################################################################

Can give a help about this??

Thk's a lot friends!

Wagner Bianchi - [phone]
Profile: bit.ly/toG94v
Blog: wagnerbianchi.com/blog
Twitter: @wagnerbianchijr
Skype: wbianchijr