MySQL Bugs: #41960: Data is corrupted while changing table and fields collations type.

Bug #41960	Data is corrupted while changing table and fields collations type.
Submitted:	8 Jan 2009 13:59	Modified:	12 Feb 2009 9:50
Reporter:	Jitendra Rathod	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S2 (Serious)
Version:	5.0.27	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	character sets, collation, convert, UTF-8

Description:
Hello,

I have installed mysql server with below detail.

MySQL charset:  UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

Currently my table's Collation = 'latin1_swedish_ci' and also its all the character field collation is 'latin1_swedish_ci'.

I want to convert my table and its fields Collation = 'utf8_general_ci'.

But the problem is when I Alter the table for changing collation, my current data is currpted.

You can take the example data from below url.. I have this job data in my database right now.

http://th.dimension.jobsdb.com/career/Default.asp?PID=3&AC=TCC&EC=TCC&GC=&JobID=395&LID=1&...

I have lots of data in my database so it is not possible to take this data again from the job.
I want to preserver my all the old data.

Waiting you positive reply ASAP.

Thanks,
Jitendra

How to repeat:
My all the data of jobs are currupted when I am going to change may table and field collation

Many thanks for writing a bug report.

Please provide output of:
SHOW CREATE TABLE <yourtable>;
SHOW VARIABLES LIKE '%char%';
SHOW VARIABLES LIKE '%coll%';

Which environment encoding did you use for input data?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".