1. ptrouw
  2. RO CSVI
  3. Monday, 01 February 2016
  4.  Subscribe via email
Error
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT `csvi_name`,`component_name`,`component_table`,`isprimary` FROM `z123_csvi_availablefields` AS `tbl` LEFT JOIN `z123_csvi_availabletables` AS `t` ON `t`.`template_table` = `tbl`.`component_table` WHERE `tbl`.`action` = 'import' AND `t`.`action` = 'import' AND `tbl`.`component` = 'com_virtuemart' AND `t`.`component` = 'com_virtuemart' AND `t`.`task_name` = 'product' GROUP BY `csvi_name`,`component_table` ORDER BY `csvi_name` ASC

All table have utf8_unicode_ci except _csvi_availablefields which has: utf8_general_ci
So I changed this to unicode all seems well.

But after update "available fields", it recreates the table, and it is back to utf8_general_ci!
SO I did again change it unicode, and this seems to work.
Accepted Answer Pending Moderation
Hello,
This seems strange for me as Joomla tables are not utf8_unicode_ci by default and neither CSVI tables. Is there any reason for having tables to be unicode?

You will be having this csvi_availablefields table issue everytime you update available fields as csvi_availablefields table is been deleted and created again during this operation.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Half of all my tables are in utf8_unicode_ci, the other half in utf8_general_ci. I don't know the reason, perhaps changed after using upgrade wizard!
There is as far as I know one reason to use unicode: we use German as well and Unicode collation sorts "ß" like "ss" where as _general_ci sorts them as single characters.

Do you for see any languages issues?
Should I change all table back to utf8_general_ci?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

The SQL statements used by both Joomla and CSVI actually don't state which collation to use, the only thing they state is to use UTF8 as character set. The collation is set by the database, whichever is the default for that database.

I don't forsee any issues as CSVI is using the same defaults as Joomla is.

There is as far as I know one reason to use unicode: we use German as well and Unicode collation sorts "ß" like "ss" where as _general_ci sorts them as single characters.
That is not something I am aware of.

Should I change all table back to utf8_general_ci?
I don't think it makes any difference for Joomla/CSVI if you use utf8_general_ci or utf8_unicode_ci as long as you make sure all tables and fields are the same. Perhaps you need to change the database default, so any new tables will be created with your preferred collation.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!