دلیل استفاده از utf8_unicode_ci به جای utf8_general_ci در جوملا فارسی 2.5 ؟!

[H@m3d]

بیش*تر بحث من روی کالکشن*های utf8_general_ci و utf8_unicode_ci بود


اینم از اروری که موقع دسترسی به بعضی قسمت*های جوملا گالری نشون داده میشه (وقتی موقع ساخت دیتابیس کالکشن utf8_general_ci هست)

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and  (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS  language_title,ua.id AS ratinguserid, ua.username AS ratingusername,  ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id  AS category_id FROM `umi8n_phocagallery_votes` AS a LEFT JOIN `umi8n_languages` AS l ON l.lang_code = a.language LEFT JOIN umi8n_users AS ua ON ua.id=a.userid LEFT JOIN umi8n_users AS uc ON uc.id=a.checked_out LEFT JOIN umi8n_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and  (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS  language_title,ua.id AS ratinguserid, ua.username AS ratingusername,  ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id  AS category_id FROM `umi8n_phocagallery_votes` AS a LEFT JOIN `umi8n_languages` AS l ON l.lang_code = a.language LEFT JOIN umi8n_users AS ua ON ua.id=a.userid LEFT JOIN umi8n_users AS uc ON uc.id=a.checked_out LEFT JOIN umi8n_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and  (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.*,l.title AS  language_title,ua.id AS ratinguserid, ua.username AS ratingusername,  ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id  AS category_id FROM `umi8n_phocagallery_votes` AS a LEFT JOIN `umi8n_languages` AS l ON l.lang_code = a.language LEFT JOIN umi8n_users AS ua ON ua.id=a.userid LEFT JOIN umi8n_users AS uc ON uc.id=a.checked_out LEFT JOIN umi8n_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc

اینم اروری که وقتی موقع ساخت دیتابیس کالکشن utf8_unicode_ci هست (با ارور بالایی فرق میکنه)

Table 'joomlafarsi.qkd6q_phocagallery_votes' doesn't exist SQL=SELECT  a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS  ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS  category_title, c.id AS category_id FROM `qkd6q_phocagallery_votes` AS a LEFT JOIN `qkd6q_languages` AS l ON l.lang_code = a.language LEFT JOIN qkd6q_users AS ua ON ua.id=a.userid LEFT JOIN qkd6q_users AS uc ON uc.id=a.checked_out LEFT JOIN qkd6q_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'joomlafarsi.qkd6q_phocagallery_votes' doesn't exist SQL=SELECT  a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS  ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS  category_title, c.id AS category_id FROM `qkd6q_phocagallery_votes` AS a LEFT JOIN `qkd6q_languages` AS l ON l.lang_code = a.language LEFT JOIN qkd6q_users AS ua ON ua.id=a.userid LEFT JOIN qkd6q_users AS uc ON uc.id=a.checked_out LEFT JOIN qkd6q_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Table 'joomlafarsi.qkd6q_phocagallery_votes' doesn't exist SQL=SELECT  a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS  ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS  category_title, c.id AS category_id FROM `qkd6q_phocagallery_votes` AS a LEFT JOIN `qkd6q_languages` AS l ON l.lang_code = a.language LEFT JOIN qkd6q_users AS ua ON ua.id=a.userid LEFT JOIN qkd6q_users AS uc ON uc.id=a.checked_out LEFT JOIN qkd6q_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc

- با آخرین نسخه ومپ سرور تست شده.
- این ارورها در جوملاهای منتشر شده در بقیه جاها، وجود نداره.
- با تغییر کالکشن تمامی جداول به utf8_general_ci مشکل حل میشه.

موفق باشید