Categories
View Replies (7)

Resolved Different Collations

  1. ABINDER
    ABINDER
  2. RO CSVI
  3. Wednesday, 07 March 2018
  4.  Subscribe via email
I had this issue:
https://csvimproved.com/support/questions-and-answers/3536-deal-with-different-collations-in-mysql

Solved it like described in the kb.
But i still get the same error - all my tables in database are now utf8_unicode_ci

Are there any ideas what is still going wrong?

Thx and kind regards
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Which import are you using? Can you check the concerned VirtueMart tables of your import? I mean if you are using VirtueMart product import check your #__virtuemart_products table and #__virtuemart_products_xx_xx (where xx_xx is the language). Click on the structure tab of the table and see if you see any difference in Collation.
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
ABINDER
ABINDER
Accepted Answer Pending Moderation
Hi!

Thank you - i did the Produkt Import - and checked the Tablestrukture you told me.
At some tables are no entry at kollation and at the others all utf8_unicode_ci
Attachments (1)
1231231.PNG 1231231.PNG
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
At some tables are no entry at kollation and at the others all utf8_unicode_ci

The collation is only on text fields and so its empty for other type fields. How about your #__virtuemart_products_xx_xx language table?
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
ABINDER
ABINDER
Accepted Answer Pending Moderation
Thank you´

All exepted the key is utf8_unicode_ci :-(
I also uninstalled the Component and Reinstalled but same issue....
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I also uninstalled the Component and Reinstalled but same issue....

This is not the problem with CSVI component but with your database so reinstalling component wont help. I noticed that VirtueMart tables have utf8_general_ci as collation but you have utf8_unicode_ci as collation set. Was this updated by you?
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. # 5
ABINDER
ABINDER
Accepted Answer Pending Moderation
Hi again!

I mean i reinstalled the virtuemart com and deleted the tables once and recreated at reinstall. I also changed to utf8_general_ci with no effect. I also did a fresh install (new instance) with same problem...

Kind regards
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you check the collation of your of your database too? Click on your database name in PhpMyAdmin and on the right side, click on Operations tab and check the collation.
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. # 7
  • Page :
  • 1


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