OrdaSoft forum
utf8mb4_unicode_ci Collation - issues (0 viewing)
Joomla Translate component support
Favoured: 0
|
Utf8mb4_unicode_ci Collation - issues
Re:utf8mb4_unicode_ci Collation - issues 4 Years ago
Karma: 0
Hi Andrew,
many thanks for your answer, Please:
A - "...remove indexes for these tables..." = Please, Can you point me on the right way to do it ? To which tables, columns, of SEF Translate?
B - "...do collation change..." = I will apply the "First" and "Second" steps as I wrote in my first topic, Am I right ?
C - "...and recreate indexes again..." Again, Please, Can you point me on the right way to do it ?
many thanks for your answer, Please:
A - "...remove indexes for these tables..." = Please, Can you point me on the right way to do it ? To which tables, columns, of SEF Translate?
B - "...do collation change..." = I will apply the "First" and "Second" steps as I wrote in my first topic, Am I right ?
C - "...and recreate indexes again..." Again, Please, Can you point me on the right way to do it ?
Logged
The administrator has disabled public write access.
Re:utf8mb4_unicode_ci Collation - issues 4 Years ago
Karma: 102
With help PHPMyAdmin you may easy remove Table Index and after to create new index.
Please check attachment image.
Please first check this on any Test table
Regards
OrdaSoft team
Please check attachment image.
Please first check this on any Test table
Regards
OrdaSoft team
Logged
The administrator has disabled public write access.
Re:utf8mb4_unicode_ci Collation - issues 4 Years ago
Karma: 0
Thanks! So, as far as I understand, I have to delete these 4 (four) indexes:
1 - on seftranslate_files: photos.app.goo.gl/Na3c4aHDRqFRZRUY9
2 - on seftranslate_urls: photos.app.goo.gl/C17px1DThGp3T6QT9
3 and 4 - on seftranslate:url_connect: photos.app.goo.gl/3PSaaWLdANH8USK98
and then I'll recreate them right ?
1 - on seftranslate_files: photos.app.goo.gl/Na3c4aHDRqFRZRUY9
2 - on seftranslate_urls: photos.app.goo.gl/C17px1DThGp3T6QT9
3 and 4 - on seftranslate:url_connect: photos.app.goo.gl/3PSaaWLdANH8USK98
and then I'll recreate them right ?
Logged
The administrator has disabled public write access.
Re:utf8mb4_unicode_ci Collation - issues 4 Years ago
Karma: 102
Hello
Yes,
Regards
OrdaSoft team
Yes,
Regards
OrdaSoft team
Logged
The administrator has disabled public write access.
Re:utf8mb4_unicode_ci Collation - issues 4 Years ago
Karma: 0
Hi Andrew,
really many thanks!
About 4 - By deleting and recreating the indexes the limit issue is avoided and I don't have to add the characters limit (765) on those indexes, Am I right ?
Or, Should I have to add a 765 limit when recreating the mentioned indexes ?
really many thanks!
About 4 - By deleting and recreating the indexes the limit issue is avoided and I don't have to add the characters limit (765) on those indexes, Am I right ?
Or, Should I have to add a 765 limit when recreating the mentioned indexes ?
Logged
The administrator has disabled public write access.
Re:utf8mb4_unicode_ci Collation - issues 4 Years ago
Karma: 102
I as developer think - the DataBase must, by default, create so best index as possible. But the Database must permit change this.
If you not have some database size limit, the more long index will give better performance
Regards
OrdaSoft team
If you not have some database size limit, the more long index will give better performance
Regards
OrdaSoft team
Logged
The administrator has disabled public write access.
 |
we support payment systems
