Public Forums 71,145 posts

[chacapamac Friend chacapamacJoin date: March 2009Posts: 65Downloads:0Uploads:7 Thanks: 7 Thanked: 1 times in 1 posts]

#139381

When I create a new database in MAMP sometime the collation is:

Template Opal: latin1_swedish_ci

Template Zinc: utf8_general_ci

How come and what I should do?

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#298410

Hi chacapamac,

You should use utf8_general_ci.

Thanks.

[chacapamac Friend chacapamacJoin date: March 2009Posts: 65Downloads:0Uploads:7 Thanks: 7 Thanked: 1 times in 1 posts]

#298469

How do I changed this and do you see any problems doing so?

[dufi Friend dufiJoin date: April 2012Posts: 20Downloads:120Uploads:7 Thanks: 10]

#491614

<em>@chacapamac 120813 wrote:</em><blockquote>How do I changed this and do you see any problems doing so?</blockquote>
Looks this is JA common problem…and finally nobody cares. Same problem is (Database Collation latin1_swedish_ci) is with OnePage template. I already rewrited each table to utf8_general_ci, but problem still exists 🙁
Anyway, I can see this post is unanswered for 4 years, so this is the way how JA support works..

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#491755

You have to change the collation(utf8_general_ci) before you install Joomla.

Open your empty database with PhpMyadmin, click on Operations and change the collation.

1 user says Thank You to Ninja Lead for this useful post

1. adits

[Author]

Posts