Categories
You need to be logged in to view a user's profile.
View Replies (3)

Resolved Illegal mix of collations

  1. athenacraftsltdltd
    athenacraftsltdltd
  2. RO CSVI
  3. Wednesday, 13 February 2019
  4.  Subscribe via email
Hi All!

I'm getting an error "Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='" when I'm importing a file via cron job.

I've researched the error and found this vary helpful looking document: https://csvimproved.com/support/questions-and-answers/3536-deal-with-different-collations-in-mysql

How do I find where the field in question is? I've checked both the tables specified in the previous entry in the log and their collations match.
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You did not mention which import you are running to help you with the tables related to that import. Can you give us those details?

Also if you see all collations are correct and still you see the error, check if your import file is UTF-8 encoded. This is also explained in the document.
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
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
Hi Tharuna,
Thanks. I was importing a product import. It was a data issue - the files are not usually exported as UTF-8 encoded, but it doesn't usually matter because there are usually no characters that need such encoding. Today a foreign character slipped in (é).
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes, when you have accented characters it is a must that your file has to be UTF-8 encoded. Encoding is a problem with the program you use to open your export file and so we recommend to use OpenOffice or LibreOffice.
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. # 3
  • Page :
  • 1


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