Meeting Collation problem first time.

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
FuzMic
Joomla! Explorer
Joomla! Explorer
Posts: 405
Joined: Mon Oct 08, 2012 4:45 am

Meeting Collation problem first time.

Post by FuzMic » Sun Aug 07, 2022 2:31 pm

Hi gurus

My localhost has mysql v5.7.26 use collation utf8_unicode_ci while my service provider collation is utf8mb4_unicode_ci.
Can I set both localhost & server collation to utf8mb4_unicode_ci will the transfer work without error.
I wanted to set both localhost & server to utf8_unicode_ci but the server has only utf8mb4_unicode_ci, utf8mb3, utf32, utf16.

What I found is inspite of setting server to utf8mb4_unicode_ci the sql shows
DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci;

And there is error when importing #1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
The error last line is
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

.... Very confusing, HELP

By the way what is best practice in this situation?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 29293
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Meeting Collation problem first time.

Post by Per Yngve Berg » Sun Aug 07, 2022 2:52 pm

There was an update to utf8mb4_unicode_ci in 3.9.x somewhere from utf8.

FuzMic
Joomla! Explorer
Joomla! Explorer
Posts: 405
Joined: Mon Oct 08, 2012 4:45 am

Re: Meeting Collation problem first time.

Post by FuzMic » Mon Aug 08, 2022 1:28 am

Bro
..update to utf8mb4_unicode_ci in 3.9.x somewhere from utf8..
Is it from MySQL & what 3.9.x refers to what? Much obliged

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4126
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Meeting Collation problem first time.

Post by abernyte » Mon Aug 08, 2022 4:02 am

Use utf8mb4_unicode_ci which can store any unicode character and not utf8, which is limited to what can be stored.
Around Joomla 3.9.x was when the change to utf8mb4 occurred for Joomla, which is what @Per referred to.
Your phpMyAdmin in your localhost can change the database collation effectively but taking a database backup first is not a bad idea.
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41889
Joined: Sat Apr 05, 2008 9:58 pm

Re: Meeting Collation problem first time.

Post by Webdongle » Mon Aug 08, 2022 10:51 am

https://extensions.joomla.org/extension/admin-tools/ can be used to change database collation
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".


Post Reply

Return to “General Questions/New to Joomla! 3.x”