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
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to