Switching a web site to UTF-8 - Revision history

Shawn: /* Steps */

2013-04-24T17:54:40Z

Steps

← Older revision		Revision as of 10:54, 24 April 2013
Line 7:		Line 7:
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	;Convert all php scripts to use UTF-8 as the default character set.		;Convert all php scripts to use UTF-8 as the default character set.
	;Convert all mysql connections and requests to use UTF-8.		;Convert all mysql connections and requests to use UTF-8.:I inserted the code in my connection files, which are shared by all pages using any MySQL connection:
			mysqli_set_charset($ETONewsConnect, "utf8");
	;Ensure all output from the database is properly treated.:I usually used htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8') or nl2br(htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8')).		;Ensure all output from the database is properly treated.:I usually used htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8') or nl2br(htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8')).
	;Convert all files on the web server to UTF-8.:I use Dreamweaver, so I just changed DW's preferences to use UTF-8 as the default, saved files as I made other edits, then uploaded them again.		;Convert all files on the web server to UTF-8.:I use Dreamweaver, so I just changed DW's preferences to use UTF-8 as the default, saved files as I made other edits, then uploaded them again.

Shawn at 17:41, 24 April 2013

2013-04-24T17:41:21Z

← Older revision		Revision as of 10:41, 24 April 2013
Line 2:		Line 2:

	===Steps===		===Steps===
	#Convert all the existing data in every text field of every table in the database. This is the toughest part, because data in a field may not match the declared character set of the field itself, so converting might mangle unexpected characters. It is mentioned in the tutorials below that one might convert the contents of a field to the declared character set of that field before converting it to UTF-8.		;Convert all the existing data in every text field of every table in the database:This is the toughest part, because data in a field may not match the declared character set of the field itself, so converting might mangle unexpected characters. It is mentioned in the tutorials below that one might convert the contents of a field to the declared character set of that field before converting it to UTF-8. I used the ALTER TABLE command on each table, and when I wasn't sure whether it'd mess it up, I exported the table as an SQL file before and after the conversion, then compared the two using Apple's FileMerge program. Usually there were no differences in the two backups so I knew that data was not corrupted.
	#Convert all the html pages to declare UTF-8 as their encoding. This is done in the META tag in the header.		ALTER TABLE tablename CONVERT TO CHARSET utf8
	#Convert all php scripts to use UTF-8 as the default character set.		;Convert all the html pages to declare UTF-8 as their encoding.:This is done in the META tag in the header.
	#Convert all mysql connections and requests to use UTF-8.		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	#Ensure all output from the database is properly treated, usually ~~using~~ htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8') or nl2br(htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8')).		;Convert all php scripts to use UTF-8 as the default character set.
	#Convert all files on the web server to UTF-8		;Convert all mysql connections and requests to use UTF-8.
	#OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive.		;Ensure all output from the database is properly treated.:I usually used htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8') or nl2br(htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8')).
	#Use a validator to check that pages are really being served in UTF-8. http://validator.w3.org/i18n-checker/		;Convert all files on the web server to UTF-8.:I use Dreamweaver, so I just changed DW's preferences to use UTF-8 as the default, saved files as I made other edits, then uploaded them again.
			;OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive. This didn't work for me because that directive is not allowed on my hosting server.
			;Use a validator to check that pages are really being served in UTF-8.: http://validator.w3.org/i18n-checker/

	===Existing tutorials===		===Existing tutorials===

Shawn at 18:50, 17 April 2013

2013-04-17T18:50:09Z

← Older revision		Revision as of 11:50, 17 April 2013
Line 6:		Line 6:
	#Convert all php scripts to use UTF-8 as the default character set.		#Convert all php scripts to use UTF-8 as the default character set.
	#Convert all mysql connections and requests to use UTF-8.		#Convert all mysql connections and requests to use UTF-8.
			#Ensure all output from the database is properly treated, usually using htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8') or nl2br(htmlentities($row_rsData['whatever'], ENT_COMPAT, 'UTF-8')).
	#Convert all files on the web server to UTF-8		#Convert all files on the web server to UTF-8
	#OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive.		#OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive.

Shawn: /* Steps */

2013-04-16T21:45:56Z

Steps

← Older revision		Revision as of 14:45, 16 April 2013
Line 8:		Line 8:
	#Convert all files on the web server to UTF-8		#Convert all files on the web server to UTF-8
	#OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive.		#OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive.
			#Use a validator to check that pages are really being served in UTF-8. http://validator.w3.org/i18n-checker/

	===Existing tutorials===		===Existing tutorials===

Shawn at 20:52, 16 April 2013

2013-04-16T20:52:58Z

← Older revision		Revision as of 13:52, 16 April 2013
Line 6:		Line 6:
	#Convert all php scripts to use UTF-8 as the default character set.		#Convert all php scripts to use UTF-8 as the default character set.
	#Convert all mysql connections and requests to use UTF-8.		#Convert all mysql connections and requests to use UTF-8.
			#Convert all files on the web server to UTF-8
			#OPTIONAL—Use .htaccess to direct httpd to serve all html, htm, and php files as UTF-8 with the AddCharset directive.

	===Existing tutorials===		===Existing tutorials===
Line 12:		Line 14:
	;Converting Database Character Sets << WordPress Codex		;Converting Database Character Sets << WordPress Codex
	:http://codex.wordpress.org/Converting_Database_Character_Sets		:http://codex.wordpress.org/Converting_Database_Character_Sets
			;Making sure .php files are served as UTF-8, and announced properly in the header
			:http://stackoverflow.com/questions/4279282/set-http-header-to-utf-8-php
			:and
			:http://www.w3.org/International/questions/qa-changing-encoding
			:and
			:http://www.w3.org/International/questions/qa-htaccess-charset

	[[Category:internet]]		[[Category:internet]]

Shawn: /* Steps */

2013-04-16T18:05:35Z

Steps

← Older revision		Revision as of 11:05, 16 April 2013
Line 2:		Line 2:

	===Steps===		===Steps===
	#Convert all the existing data in every text field of every table in the database.		#Convert all the existing data in every text field of every table in the database. This is the toughest part, because data in a field may not match the declared character set of the field itself, so converting might mangle unexpected characters. It is mentioned in the tutorials below that one might convert the contents of a field to the declared character set of that field before converting it to UTF-8.
	#Convert all the html pages to declare UTF-8 as their encoding.		#Convert all the html pages to declare UTF-8 as their encoding. This is done in the META tag in the header.
	#Convert all php scripts to use UTF-8 as the default character set.		#Convert all php scripts to use UTF-8 as the default character set.
	#Convert all mysql connections and requests to use UTF-8.		#Convert all mysql connections and requests to use UTF-8.

	===Existing tutorials===		===Existing tutorials===
	;Converting a MySQL database to UTF-8		;Converting a MySQL database to UTF-8

Shawn: /* Existing tutorials */

2013-04-16T18:01:40Z

Existing tutorials

← Older revision		Revision as of 11:01, 16 April 2013
Line 7:		Line 7:
	#Convert all mysql connections and requests to use UTF-8.		#Convert all mysql connections and requests to use UTF-8.
	===Existing tutorials===		===Existing tutorials===
	http://www.drzycimski.com/programming/zend-framework/converting-a-mysql-database-to-utf-8/		;Converting a MySQL database to UTF-8
			:http://www.drzycimski.com/programming/zend-framework/converting-a-mysql-database-to-utf-8/
			;Converting Database Character Sets << WordPress Codex
			:http://codex.wordpress.org/Converting_Database_Character_Sets

	[[Category:internet]]		[[Category:internet]]

Shawn: Created page with "I'd enjoy a web site that had zero issues with characters rendered improperly, so I'm considering converting my web sites to use the UTF-8 character set for storage and presen..."

2013-04-16T17:45:06Z

Created page with "I'd enjoy a web site that had zero issues with characters rendered improperly, so I'm considering converting my web sites to use the UTF-8 character set for storage and presen..."

New page

I'd enjoy a web site that had zero issues with characters rendered improperly, so I'm considering converting my web sites to use the UTF-8 character set for storage and presentation.

===Steps===
#Convert all the existing data in every text field of every table in the database.
#Convert all the html pages to declare UTF-8 as their encoding.
#Convert all php scripts to use UTF-8 as the default character set.
#Convert all mysql connections and requests to use UTF-8.
===Existing tutorials===
http://www.drzycimski.com/programming/zend-framework/converting-a-mysql-database-to-utf-8/

[[Category:internet]]