Some MySQL 5 installs don't like charset statement

[schwim]

Hi there guys,

In one of my scripts, I wrote into the upgrade portion of my script to detect version of MySQL and if > 4.0, then alter the character set to UTF 8 to allow for the language template system.

The problem I'm having is that some users have reported that their MySQL install balks at the attempt to alter the charset to UTF8. I'm pretty sure that they all had MySQL v. 5, but nobody provided any more info concerning the environment. They have to manually install the script using the 3.xx db drop because their db won't allow the later db drop w/the charset statement.

My question is should I be using another method to decide when to use the charset statements? Obviously my method isn't the way to go.

thanks,
json

[schwim]

Hi there guys,

Any thoughts on this? The next version is about to head out the door, and it would rock if I could resolve this issue before it does.

thanks,
json