I tried using
`mysqldump $log -v -Q -c --set-charset --default-character-set=utf8
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick $db_name -r $bk_file 2>&1`
and I still get
-- MySQL dump 10.9
--
-- Host: localhost Database: --
------------------------------------------------------
-- Server version 4.1.14-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `access`
--
DROP TABLE IF EXISTS `access`;
CREATE TABLE `access` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I need it to output to utf8 as I've said in my previous post. How come
--default-character-set=utf8
didn't change it? Internally it's stored as utf8 and I've read
mysqldump outputs to utf8 as default.
Yet I'm seeing latin1. What gives?
Thanks,
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Nov 7, 2005, at 9:33 PM, Boysenberry Payne wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]