Using MySQL 4=2E1=2E1-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=BC =C3~\ =C3=B6 =C3~V =C3=A4 =C3~D =C3~_'=
);
### end of script ###

This is the UTF8 -reprtesentation for "ü =DC ö =D6 ä =C4 ß"=2E=
The upper case
umlaute and s-sharp are not created correctely=2E

The text of the database field is "=C3=BC =C3? =C3=B6 =C3? =C3=A4 =C3? =
=C3?"

Nevertheless , the following works:

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

insert into test values('=C3=BC =C3~\ =C3=B6 =C3~V =C3=A4 =C3~D =C3~_'=
);
### end of script ###

Other databases like IBM-DB2 do not show this strange behavior=2E

R=2E Rohmfeld

____________________________________________
EMUGE - Werk Richard Glimpel GmbH & Co=2E KG
Fabrik für Präzisionswerkzeuge
D-91207 Lauf, Germany
e-mail: Rainer=2ERohmfeld [at] emuge=2Ede
http://www=2Eemuge=2Ede
=



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

Hi!

On May 21, Rainer.Rohmfeld [at] 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 <serg [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ 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 [at] m.gmane.org

---------- 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 <serg [at] mysql.com>
> / /|_/ / // /\ \/ /_/ / /__ 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 [at] m.gmane.org