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]