mysqlsubtropolix.org
Date: Wed Nov 07 2007 - 19:17:02 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

James Sherwood wrote:
> Hello,
>
> Thanks for the info,
>
> For the dump, I would imagine that it is latin1 as mysql 4.x is
> defaulted to that I beleive.
>
> Is there a way to dump it to utf8?
>

You can convert it using iconv:
http://climbtothestars.org/archives/2004/07/18/converting-mysql-database-contents-to-utf-8/

There's a Win version available if you don't already have it:
http://gnuwin32.sourceforge.net/packages/libiconv.htm

Be sure to edit the CHARSET refs in the dumpfile, though:

sed -i "" 's/latin1/utf8/g' dump.sql

This article may be useful:
http://dev.mysql.com/tech-resources/articles/4.1/unicode.html

brian

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]