MySQL Bugs: #3793: Polish letters

Bug #3793	Polish letters
Submitted:	17 May 2004 9:22	Modified:	3 Jun 2004 12:29
Reporter:	Wojciech Ma³ota	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:		OS:	Windows (Win98, Win2000)
Assigned to:	Ulrich Bayer	CPU Architecture:	Any

Description:
I have a website in the Internet and a copy of this site on my local Apachje Web Server. I have a backup of my database saved in the SQL fromat.
In the fields of the database are polish letters (like ¹, æ, œ, Ÿ, etc.)
When I want to update my lokal database with "Restore" tool, which is included into MySQL Administrator I have an error, because teh program can't proceed with polish letters. The programs execute queries but when it have a polish letter in the next query it doesn't proceed any next query.

How to repeat:
If you want to see this error you should have a file like this:

CREATE TABLE dzial (
  id int(11) NOT NULL auto_increment,
  tytul varchar(100) default NULL,
  kolejnosc int(11) default NULL,
  link varchar(200) default NULL,
  blank int(11) default NULL,
  typ varchar(100) default NULL,
  opiekun int(11) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY tytul (tytul)
) TYPE=MyISAM;
INSERT INTO dzial VALUES (1,'Nowiny',2,'',0,'aktualnosci',6);
INSERT INTO dzial VALUES (2,'Artyku³y',3,'',0,'relacje',3);

Next, you should use a "Restore" tool to restore the backup file.
You will see tah table "dzial" is created and the first row is added.
But the second row isn't added because it has a polish letter (³).

I tested your big case but I found another behavior.
First I created the table and inserted data, done the
backup, drop the table and done the backup.

Both rows were inserted but the column with Polish
character incomplete.

mysql> select * from dzial;
+----+---------+-----------+------+-------+-------------+---------+
| id | tytul   | kolejnosc | link | blank | typ         | opiekun |
+----+---------+-----------+------+-------+-------------+---------+
|  1 | Nowiny  |         2 |      |     0 | aktualnosci |       6 |
|  2 | Artyku³ |         3 |      |     0 | relacje     |       3 |
+----+---------+-----------+------+-------+-------------+---------+
2 rows in set (0.00 sec)

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Hi,

Thanks for your bug-report.
We have fixed all charset-related problems in the new 1.0.4 Windows Beta version that we will release in some hours. If there should be any problems
left don't forget to tell me your server version. There is a big difference in charset support between 4.0 and 4.1.