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:Microsoft Windows (Win2000)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: I have uploaded a sample latin2 dump file (bug-data-24723.zip)

[30 Nov 2006 11:25] Nándor Horgos
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.
[30 Nov 2006 23:44] MySQL Verification Team
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.
[6 Dec 2006 16:52] MySQL Verification Team
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.