Strange behavior with UTF8 and german umlaute

Using MySQL 411-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=3Dutf8;

insert into test values('ü =C3~\ ö =C3~V ä =C3~D =C3~_'=
);
### 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 "ü =C3? ö =C3? ä =C3? =
=C3?"

Nevertheless , the following works:

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

insert into test values('ü =C3~\ ö =C3~V ä =C3~D =C3~_'=
);
### 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: RainerRohmfeld@emugede
http://wwwemugede
=



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: Strange behavior with UTF8 and german umlaute

Hi!

On May 21, Rainer.Rohmfeld@emuge.de wrote:
> 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 "ü � ö � ä � �"

I cannot repeat it - everything works ok in the latest 4.1.2. Probably
the bug was already fixed after 4.1.1 release.

Check that you have done 'SET NAMES utf8' before issuing the insert.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Re: Strange behavior with UTF8 and german umlaute

---------- Original Message ----------------------------------

>I cannot repeat it - everything works ok in the latest 4.1.2. Probably
>the bug was already fixed after 4.1.1 release.
>
>Check that you have done 'SET NAMES utf8' before issuing the insert.
>
>Regards,
>Sergei
>
>--
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Sergei Golubchik
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
>/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
> <___/ www.mysql.com
>

Thanks, it is working this way.

On the other hand, it is hidden inside the documentation (11.3.12 last paragraph), that the connection should als use utf8 via SET NAMES or character_set_connection. It would be best, to have this in a more central place, for users who deal with UTF8 databases.

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org