MySQL Forums
Forum List  »  Other Migration

how to convert non-utf8 char to multibyte characters using mysqldump
Posted by: Manoj Patil
Date: December 06, 2010 07:14AM

Hi Experts,

I have a strange requirement while copying the data from mysql to vertica. There are some German characters like 'ä'. This as is is not supported by vertica. So I want to convert it to multibyte characters like "ä" which while reading from JDBC, gets converted to utf-16 correctly.

Now I tried to use --default-character-set=utf8 while executing mysqldump but still I am getting the single non-utf8 character in the exported data.

Is there any option using which I can export the data to pure utf8 (or rather ANSI)?

Thanks in Advance,
manoj

Options: ReplyQuote


Subject
Views
Written By
Posted
how to convert non-utf8 char to multibyte characters using mysqldump
5157
December 06, 2010 07:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.