How to change coding type for PhpMyadmin database

**3DProf4online** · 05-06-2008, 03:57 PM

I have old version of PhpMyadmin and would like to setup utf-8 coding type for my database. Now coding type is set by default and when I try to display database data they are coded improperly. Is any way to change coding type in phpmyadmin?

**joder** · 05-10-2008, 12:12 AM

At the place to enter SQL

Code:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

05-06-2008, 03:57 PM	#1 (permalink) How to change coding type for PhpMyadmin database
3DProf4online Average Talker Posts: 18 Talkupation:	I have old version of PhpMyadmin and would like to setup utf-8 coding type for my database. Now coding type is set by default and when I try to display database data they are coded improperly. Is any way to change coding type in phpmyadmin? __________________ http://hostingcoupons.com

05-10-2008, 12:12 AM	#2 (permalink) Re: How to change coding type for PhpMyadmin database
joder Flipotron Posts: 5,152 Name: James Location: In the ocean. Talkupation:	At the place to enter SQL Code: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;