Re: ß and Æ
Posted by: Peter Gulutzan
Date: May 15, 2006 11:13AM

Hi,

I don't know your version and settings
and definitions.
I can only say that ß = ss for me.

mysql> select version();
+--------------+
| version() |
+--------------+
| 5.0.22-debug |
+--------------+
1 row in set (0.00 sec)

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> create table tspam (s1 char(10)
-> character set utf8
-> collate utf8_unicode_ci);
Query OK, 0 rows affected (0.04 sec)

mysql> insert into tspam values ('strasse'),('straße');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> select * from tspam where s1='strasse';
+---------+
| s1 |
+---------+
| strasse |
| straße |
+---------+
2 rows in set (0.00 sec)

Peter Gulutzan
MySQL AB

Options: ReplyQuote


Subject
Views
Written By
Posted
2830
May 11, 2006 08:58AM
Re: ß and Æ
1784
May 15, 2006 11:13AM
1777
May 18, 2006 08:13AM
1919
May 21, 2006 10:03AM
1823
May 21, 2006 10:34AM


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.