MySQL - Revision history

WikiSysop at 19:09, 23 August 2013

2013-08-23T19:09:56Z

WikiSysop at 02:40, 12 July 2013

2013-07-12T02:40:05Z

WikiSysop at 09:08, 16 July 2011

2011-07-16T09:08:38Z

WikiSysop at 17:49, 19 November 2010

2010-11-19T17:49:01Z

WikiSysop at 18:03, 15 September 2010

2010-09-15T18:03:42Z

116.12.248.162 at 02:48, 19 June 2009

2009-06-19T02:48:13Z

220.255.7.179 at 01:31, 19 June 2009

2009-06-19T01:31:01Z

WikiSysop at 14:51, 18 June 2009

2009-06-18T14:51:54Z

New page

<pre>
ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_links` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_options` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_postmeta` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_terms` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_term_relationships` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_term_taxonomy` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_usermeta` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
</pre>

@@ Line 24: / Line 24: @@
 [[Image:repairtable.png]]
 == See Also ==
 [[Category:Programming]]

← Older revision		Revision as of 02:40, 12 July 2013
Line 24:		Line 24:

	[[Image:repairtable.png]]		[[Image:repairtable.png]]
		+
		+	== See Also ==
		+
		+	[[Category:Programming]]

@@ Line 16: / Line 16: @@
 the default is latin_swedish cos mysql is made in sweden!
+NEW ADDITION - i think this one is new category added in new WP?
 <Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

← Older revision		Revision as of 17:49, 19 November 2010
Line 21:		Line 21:
	<Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;		<Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
	</pre>		</pre>
		+
		+	== How to repair table in phpMyAdmin ==
		+
		+	[[Image:repairtable.png]]

← Older revision		Revision as of 18:03, 15 September 2010
Line 15:		Line 15:

	the default is latin_swedish cos mysql is made in sweden!		the default is latin_swedish cos mysql is made in sweden!
		+
		+
		+	NEWWWWW
		+
		+	<Pre>ALTER TABLE wp_commentmeta DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
		+	</pre>

← Older revision		Revision as of 02:48, 19 June 2009
Line 13:		Line 13:
	ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;		ALTER TABLE `wp_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
	</pre>		</pre>
		+
		+	the default is latin_swedish cos mysql is made in sweden!

← Older revision		Revision as of 01:31, 19 June 2009
Line 1:		Line 1:
		+	== Alter collation of wordpress tables to utf8 ==
		+
	<pre>		<pre>
	ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;		ALTER TABLE `wp_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;