MySQL Bugs: #24723: There are "?" chars instead of accentuated letters (latin2 to UTF-8 migration)

Bug #24723	There are "?" chars instead of accentuated letters (latin2 to UTF-8 migration)
Submitted:	30 Nov 2006 11:25	Modified:	7 Dec 2006 14:09
Reporter:	Nándor Horgos	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.1.6	OS:	Windows (Win2000)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	I have uploaded a sample latin2 dump file (bug-data-24723.zip)

Description:
During migrating from latin2 DB (MySQL 4.0.18) to UTF-8 DB (MySQL 5.0.22) schemata creation, table creation and data import finished without any error, but in the target DB field values contain "?" instead of every accentuated letter.

How to repeat:
Migrate a latin2 charset DB (containing accentuated letters) into an UTF-8 DB.

Suggested fix:
Truncate the tables in the target DB 
export the source DB
adding a line to the exported file at the beggining: SET NAMES latin2
than import it, results correct field values.

Thank you for the bug report. I was unable to repeat migrating from 4.0.27
to 5.0.27 server. The accents I used are: á è ã ê ô. Could you please
provide a dump script with table definition and insert data commands with
accents you had used. Thanks in advance.

Thank you for the feedback. Still I am unable to repeat, notice using
MySQL Migration Toolkit. I asked a dump file just to test the same
accented characters as you.