New Error; Illegal mix of collations

I ran the commands, still getting errors.
[23-Dec-2010 01:20:50] Caught exception 'Exception' with message 'Error in DB RIS Query: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'like'.
Query: CALL jos_TeraWurfl_RIS('Mozilla/5.0 (compatible; Googlebot/2.1; +www.google.com/bot.html)',7,'Bot')
' in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:117

Is mobile joomla functioning properly with these errors? Are visitors able to view mobile content with theses errors?
Robin

Should work:

Hi,
I got this error message from sql
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1

Which of four commands produce the error?

I just ran all commands individually and all came up with syntax errors. Can I alter the table manually?

Try just

Yes. Successful. Will that fix the error?

folmag wrote:

I hope.
It seems that your db's tables was slightly corrupted (all collation parameters was reseted to 'utf8_general_ci') most likely because of incorrect backup/restore procedure.
I recommend you to reinstall MobileJoomla (just install latest version over exisiting to keep all the settings), because above commands fix TeraWurfl_RIS procedure only, and I'm not sure that there will be no problems further.

I will reinstall mobile joomla and get back to you. But so far the errors have stopped.
Thanks so much.
Robin

Hi Denis,
I am having the same problem with the Mobile Joomla Update to 0.9.11. Here is the error message in error log......
[29-Jan-2011 00:06:07] Caught exception 'Exception' with message 'Error in DB RIS Query: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='.
Query: CALL jos_TeraWurfl_RIS('Mozilla/5.0 (compatible; Googlebot/2.1; +www.google.com/bot.html)',7,'Bot')
' in /home/folmag/public_html/plugins/mobile/terawurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:116

I ran this command query in sql and it did not work this time.
ALTER TABLE jos_TeraWurflMerge MODIFY user_agent VARCHAR(255) BINARY DEFAULT NULL;

I got a successful message from sql, but the errors still keep coming.

Robin