PhpDig.net - View Single Post - Storing UTF-8 in MySQL

renehaentjens · 02-17-2005, 01:16 AM

I did a test with a HTML-page containing a TEXTAREA. The page was generated by PHP, with: header('Content-Type: text/html; charset=UTF-8');

I could input letters with accents and Greek letters. They came back correctly after having been stored in MySQL, retrieved back, and displayed again in a new UTF-8 HTML-page.

My test was with the Firefox 1.0 browser and an EasyPHP 1.7 (Windows) server, which is PHP 4.3.3 and MySQL 4.0.15. The tables in MySQL were created with all defaults in an 8859-1 environment.

Of course, if you look in the MySQL tables, e.g. with phpMyAdmin, the data looks bizarre because with this DB setup MySQL doesn't "know" that it is storing UTF-8, it just stores octet-strings. But for getting user input and re-displaying it, that doesn't matter.

02-17-2005, 01:16 AM	#2
renehaentjens Orange Mole Join Date: Nov 2003 Posts: 69	Works OK for me I did a test with a HTML-page containing a TEXTAREA. The page was generated by PHP, with: header('Content-Type: text/html; charset=UTF-8'); I could input letters with accents and Greek letters. They came back correctly after having been stored in MySQL, retrieved back, and displayed again in a new UTF-8 HTML-page. My test was with the Firefox 1.0 browser and an EasyPHP 1.7 (Windows) server, which is PHP 4.3.3 and MySQL 4.0.15. The tables in MySQL were created with all defaults in an 8859-1 environment. Of course, if you look in the MySQL tables, e.g. with phpMyAdmin, the data looks bizarre because with this DB setup MySQL doesn't "know" that it is storing UTF-8, it just stores octet-strings. But for getting user input and re-displaying it, that doesn't matter. __________________ René Haentjens, Ghent University