Converting your MySQL database to UTF8 - Revision history

Andreabix: /* Special chars won't import correctly */

2011-08-05T15:23:24Z

Special chars won't import correctly

← Older revision		Revision as of 15:23, 5 August 2011
Line 148:		Line 148:
	# cd /folder_where_your_dump_is/		# cd /folder_where_your_dump_is/
	# mysql -u your_user -p		# mysql -u your_user -p
	> create database yourdb charset=~~uf8~~;		> create database yourdb charset=utf8;
	> use yourdb;		> use yourdb;
	> SET NAMES 'utf8';		> SET NAMES 'utf8';

2011-08-05T15:22:34Z

@@ Line 142: / Line 142: @@
 Could someone who is familiar with Windows please convert the above into something that will work on Windows?
 There are likely several additional arguments for mysqldump you will need to specify including setting the file for output using -r to avoid newline issues.
 ==More information==

2011-02-17T08:37:38Z

Windows

@@ Line 142: / Line 142: @@
 Could someone who is familiar with Windows please convert the above into something that will work on Windows?
 There are likely several additional arguments for mysqldump you will need to specify including setting the file for output using -r to avoid newline issues.
 ==More information==

2011-02-17T08:36:08Z

Windows

← Older revision		Revision as of 08:36, 17 February 2011
Line 143:		Line 143:
	There are likely several additional arguments for mysqldump you will need to specify including setting the file for output using -r to avoid newline issues.		There are likely several additional arguments for mysqldump you will need to specify including setting the file for output using -r to avoid newline issues.

	I had the same problem with converting DB from latin1 to utf8. And that how I did it:
			== I had the same problem with converting DB from latin1 to utf8. And that how I did it:

	1. Export your DB to somedb.sql on your pc.		1. Export your DB to somedb.sql on your pc.
Line 154:		Line 155:
	7. Upload(import) new dump to server.		7. Upload(import) new dump to server.
	8. Check your site		8. Check your site
	Done.		Done. ==

	==More information==		==More information==

2011-02-17T08:34:34Z

Windows

@@ Line 142: / Line 142: @@
 Could someone who is familiar with Windows please convert the above into something that will work on Windows?
 There are likely several additional arguments for mysqldump you will need to specify including setting the file for output using -r to avoid newline issues.
 ==More information==

2011-01-26T13:15:00Z

Default Mysql character set

← Older revision		Revision as of 13:15, 26 January 2011
Line 55:		Line 55:
	--skip-character-set parameter, will restore the database with your new default character set of utf8.		--skip-character-set parameter, will restore the database with your new default character set of utf8.

	utf8_unicode and utf8_general are not the same but similar. The difference is described in the ~~mysql~~ documentation page.		utf8_unicode and utf8_general are not the same but similar. The difference is described in the unicode documentation page. (Link below)

	==Converting an empty database==		==Converting an empty database==

2011-01-26T13:14:05Z

Default Mysql character set

← Older revision		Revision as of 13:14, 26 January 2011
Line 55:		Line 55:
	--skip-character-set parameter, will restore the database with your new default character set of utf8.		--skip-character-set parameter, will restore the database with your new default character set of utf8.

	utf8_unicode and utf8_general are not the same but similar.		utf8_unicode and utf8_general are not the same but similar. The difference is described in the mysql documentation page.
	The ~~mysql site suggests that the main~~ difference is ~~that unicode does a better job~~
	~~when it comes to sorting and dealing with strange characters whereas general performs better~~
	in ~~terms of speed.~~

	~~Someone who really knows what they are talking about on collations might edit this please~~.

	==Converting an empty database==		==Converting an empty database==

2011-01-26T10:31:12Z

Default Mysql character set

← Older revision		Revision as of 10:31, 26 January 2011
Line 55:		Line 55:
	--skip-character-set parameter, will restore the database with your new default character set of utf8.		--skip-character-set parameter, will restore the database with your new default character set of utf8.

	~~utf_unicode~~ and ~~utf_general~~ are not the same but similar.		utf8_unicode and utf8_general are not the same but similar.
	The mysql site suggests that the main difference is that unicode does a better job		The mysql site suggests that the main difference is that unicode does a better job
	when it comes to sorting and dealing with strange characters whereas general performs better		when it comes to sorting and dealing with strange characters whereas general performs better

2011-01-26T10:30:40Z

Default Mysql character set

← Older revision		Revision as of 10:30, 26 January 2011
Line 20:		Line 20:

	To make mysql default to utf8 you can edit /etc/my.cnf as follows.		To make mysql default to utf8 you can edit /etc/my.cnf as follows.


	(This was good for ubuntu server lucid 10.04 2.6.32-24-server Jan 2011)		(This was good for ubuntu server lucid 10.04 2.6.32-24-server Jan 2011)
Line 53:		Line 54:
	Having made your default character set utf, a mysqldump restore of your database with the		Having made your default character set utf, a mysqldump restore of your database with the
	--skip-character-set parameter, will restore the database with your new default character set of utf8.		--skip-character-set parameter, will restore the database with your new default character set of utf8.

			utf_unicode and utf_general are not the same but similar.
			The mysql site suggests that the main difference is that unicode does a better job
			when it comes to sorting and dealing with strange characters whereas general performs better
			in terms of speed.

			Someone who really knows what they are talking about on collations might edit this please.

	==Converting an empty database==		==Converting an empty database==

2011-01-25T21:14:21Z

Default Mysql character set

← Older revision		Revision as of 21:14, 25 January 2011
Line 41:		Line 41:

	default-character-set=utf8		default-character-set=utf8

			default-collation=utf8_unicode_ci

	character-set-server=utf8		character-set-server=utf8