This Gentoo Wiki page suggests dumping the table and using iconv to convert the characters, then insert the dump into a new table with the new charset.
Alex King solved a different problem: his apps were talking UTF8, but his tables were Latin1. His solution was to dump the tables, change the charset info in the dump file, then re-insert the contents.
Posted October 9, 2008 by Casey
Categories: Technology. Tags: character encoding, character set, character set conversion, latin1, mysql, utf8.
No Comments Yet
No comments yet.
Comments RSS
TrackBack Identifier URI
User contributed tags for this post:
mysql (14) - iconv mysql (11) - mysql character sets (7) - Convert character encoding mysql (4) - mysql latin1 to utf iconv (3) - dump one tables convert latin1 to utf 8 mysql (3) - ww89cm video (3) - convert encoding mysql (3) - mysql character encoding (2) - converting character sets (2) - www,pinkworldcom, (2) - inser into * SET mysql (2) - convert char to cm (2) - insert mysql utf8 (2) - seexy.com (2) - mysqldump character encoding (2) - mysql character (1) - mysql char set (1) - convert charset mysql dump (1) - convert character encoding (1) - char 1 char 2 mysql (1) - character set os x mysql (1) - convert mysql utf8 (1) - mysql character set iconv (1) - mysql convert to utf8, dump (1) - mysql convert charset (1) - convert ž to UTF-8 character (1) - insert into CONVERT TO CHARACTER SET mysql (1) - mysql convert charsets (1) - mysql insert into convert (1) - mysql charEncode (1) - convert character encoding table mysql (1) - mysql encoding dump (1) - mysql character set (1) - mysql iconv (1) - mysql utf8 convert (1) - mysql utf8 egrave (1) - convert character set (1) - mysql insert convert character set (1) - iconv mysql encoding (1) - mysql insert into convert latin1 (1) - mysql char table (1) - character sets in mysql (1) - convert mysql character (1) - insert encoding mysql (1) - mysql @ character (1) - set mysql character encoding (1) - mysql and character set (1) - converting mysql to mysql (1) - mac os x convert character sets (1) - mysql CHAR encode (1) - convert mysql character set from latin1 to utf8 (1) - Mysql convert character set (1) - MySQL char (1) - mysql - character (1) - iconv mysql character sets (1) - mysql character set what (1) - convert mysql text encoding (1) - character sets mysql (1) - mysql convert character encodings (1) - mysql convert char (1) - mysql convert character utf-8 (1) - mysql insert convert utf-8 (1) - convert latin1 to utf-8 iconv mysql (1) - convert charset mysql latin1 to utf8 iconv (1) - mysql charset set convert (1) - mysql set character (1) - convert charset mysql (1) - mysql insert into egrave (1) - mysql character convert (1) - ｆａｃｅｂｏｏｋｏｆｓｅｘ (1) -
