latin1_german2_ci
Posted by: Wagner Bianchi
Date: November 12, 2007 07:51AM

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 - +55 31 8654-9510
Profile: bit.ly/toG94v
Blog: wagnerbianchi.com/blog
Twitter: @wagnerbianchijr
Skype: wbianchijr

Options: ReplyQuote


Subject
Views
Written By
Posted
latin1_german2_ci
3754
November 12, 2007 07:51AM
2192
December 17, 2007 09:22AM


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.