OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
utf8mb4_unicode_ci Collation - issues (0 viewing) 

Joomla Translate component support

Go to bottom Favoured: 0

Utf8mb4_unicode_ci Collation - issues

joomleb (User)
Gold Boarder
Posts: 202
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 5 Months 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 ?
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8243
graph
User Online Now Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 5 Months ago
Karma: 101  
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
Logged Logged
The administrator has disabled public write access.
joomleb (User)
Gold Boarder
Posts: 202
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 5 Months 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 ?
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8243
graph
User Online Now Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 5 Months ago
Karma: 101  
Hello

Yes,

Regards
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
joomleb (User)
Gold Boarder
Posts: 202
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 5 Months 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 ?
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8243
graph
User Online Now Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 5 Months ago
Karma: 101  
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
Logged Logged
The administrator has disabled public write access.
Go to top
»