PhotoPost Community - View Single Post

KrUsTyX · October 17th, 2011, 09:08 PM

It worked

ALTER DATABASE MyDb CHARACTER SET utf8;

and for each table that was not utf8

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Thru phpmyadmin

October 17th, 2011, 09:08 PM	#10 (permalink)
KrUsTyX Member Verified Customer Join Date: Aug 2007 Posts: 125	It worked ALTER DATABASE MyDb CHARACTER SET utf8; and for each table that was not utf8 ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Thru phpmyadmin Last edited by KrUsTyX; October 17th, 2011 at 09:21 PM.