Re: Special Character translation with export help needed

[Boysenberry Payne]

I think the problem is mysqldump uses this:

DEFAULT CHARSET=latin1

 with --set-charset

How can I get it to use utf8?


Thanks,
Boysenberry

boysenberrys.com | habitatlife.com | selfgnosis.com

On Nov 7, 2005, at 8:46 PM, Boysenberry Payne wrote:

I'm having difficulty getting certain special characters to stay the same when I export databases.

Here are some of the examples:

View of data from phpMyAdmin:
Habitat is a “what you see is what you get� or “WYSIWYG�

View from table dump via phpMyAdmin export:

Habitat is a “what you see is what you get� or “WYSIWYG�

View from table dump via mysqldump:

Habitat is a “what you see is what you get� or “WYSIWYG�

The view of the data via phpMyAdmin seems to be the closest to what I need. The special characters are created by flash then saved in the mysql ( 4.1.13 ) database. Now I'm moving them to a different mysql ( 4.1.14 ) database.

Is there a better way to swap databases that will prevent the special characters from being translated?

Thanks,

Boysenberry

boysenberrys.com | habitatlife.com | selfgnosis.com

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

To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]