Re: Strange behavior with UTF8 and german umlaute

Hi!

On May 21, [email protected] 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 <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  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/[email protected]