mysql error

[Ammari]

Hello,

I have been trying to solve this issue.



Database error in vBulletin 3.7.0 Release Candidate 1:
Invalid SQL:
SELECT *
FROM socialgroup
WHERE name = 'يسش'
AND groupid <> 0;
MySQL Error : Illegal mix of collations (cp1256_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
Error Number : 1267
Date : Sunday, April 6th 2008 @ 02:44:15 AM
Script : http://www.xxx/vb/group.php?do=docreate&groupid=
Referrer : http://www.xxx/vb/group.php?do=create
IP Address : xxx
Username : xxx
Classname : vb_database
MySQL Version : 5.0.58-enterprise-gpl



so I try o change the collations..
and this error appears when applying changes.


SQL query:
ALTER TABLE `socialgroup` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
MySQL said: https://admin.names.co.uk/mysqladmin/themes/original/img/b_help.png (http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html)
#1283 - Column 'description' cannot be part of FULLTEXT index





Any idea?
Thanks

[Wayne Luke]

Make sure that socialgroup is a MyISAM table then change the collation.