Strange behavior with UTF8 and german umlaute

Using  MySQL 4.1.1-alpha on  Gentoo-Linux and Win32, the following small
example has an extreme bug!

### script sample ###
create table test (
    text varchar(100) character set utf8
    )  default charset=utf8;

insert into  test values('ü Ã~\ ö Ã~V ä Ã~D Ã~_');
### end of script  ###

This is the UTF8 -reprtesentation for  "ü Ü ö Ö ä Ä ß".  The upper case
umlaute and s-sharp are not created correctely.

The text of the database field is "ü � ö � ä � �"

Nevertheless , the following works:

### script sample ###
create table test (
    text varchar(100)
    )  default charset=latin1;

insert into  test values('ü Ã~\ ö Ã~V ä Ã~D Ã~_');
### end of script ###

Other databases like IBM-DB2  do not show this strange behavior.

R. Rohmfeld

____________________________________________
EMUGE - Werk Richard Glimpel GmbH & Co. KG
Fabrik für Präzisionswerkzeuge
D-91207 Lauf, Germany
e-mail: [email protected]
http://www.emuge.de



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]