Having problems formatting "alter" command for MySQL

[schwim]

Hi there guys,

I've tried replacing all instances of single quotes with accented quotes and vice versa. I've tried no quotes at all. I also copied & pasted the command generated by phpMyAdmin. Regardless of how I do it, I'm told that I have an error at line one. It pastes the whole line, so I don't have anything to go by when trying to find out what it is.

My statement:

mysql_query("ALTER `admin` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`") or die("Cannot query the database.<br><br>" . mysql_error());

Can someone please tell me the proper way to format this statement?

thanks,
json

[NogDog]

I believe this has a better chance of working:

mysql_query("ALTER TABLE `admin` DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'") or die("Cannot query the database.<br><br>" . mysql_error());