abduraooft
08-10-2009, 06:12 PM
Hi all,
Never mind. I solved it :)
I've a table with CHARSET=latin1 with some columns of type varchar having collation latin1_swedish_ci
I need to migrate the data from this table to a table having CHARSET=utf8 and corresponding columns with collation utf8_general_ci
Can anyone recommend me a straight and appropriate procedure for doing this task? Like
The connection charset to be used
Use of functions like convert(), cast() ...
I've been following several articles and manual pages, but the data is not getting properly migrated. (For example, I've a word like xxx² in the old columns, but the new column is getting only xxx)
Thanks for any help.
Never mind. I solved it :)
I've a table with CHARSET=latin1 with some columns of type varchar having collation latin1_swedish_ci
I need to migrate the data from this table to a table having CHARSET=utf8 and corresponding columns with collation utf8_general_ci
Can anyone recommend me a straight and appropriate procedure for doing this task? Like
The connection charset to be used
Use of functions like convert(), cast() ...
I've been following several articles and manual pages, but the data is not getting properly migrated. (For example, I've a word like xxx² in the old columns, but the new column is getting only xxx)
Thanks for any help.