Re: Mysql Error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_c
Quote:
|
Originally Posted by cflsystems
You may have the table itself as utf8_unicode_ci but you also have to have all text fields in the table with the same
|
Thanks Steve,
All tables & respective text fields set to utf8_general_ci & problem resolved.
Now only one x-cart table "xcart_words_en" gives similar error.
It's safe to alter this table & it's text fields to utf8_general_ci ?
__________________
X-Cart: 4.7.7 LIVE
Skin:Ultra by xcartmods.co.uk
X-cart Modules: | ACR, Rich Google Search, Customer Testimonials | Cloud Search, | Websitecm: CDSEO (2.1.9)
---------------
Server: Linux
php: 5.3
mysql: 5.0.89
----------------
|