Welcome Guest. Please Login or Register  


You are here: Index > Softaculous Auto Installer > Languages and International Support > Topic : latin1_swedish_ci --> utf8_general_ci



Threaded Mode | Print  

 latin1_swedish_ci --> utf8_general_ci, This should be utf8_general_ci collation for non Latin speaking world: latin1_swedish_ci --> utf8_general_ci (8 Replies, Read 38807 times)
lucky_sevenf
Group: Member
Post Group: Newbie
Posts: 4
Status:
Hi,

It seems that when your script installs WP, it auto creates the database in MySQL that is based on latin1_swedish_ci collation as default.

This should be utf8_general_ci collation for non Latin speaking world:
latin1_swedish_ci --> utf8_general_ci

Can you make this change so that everyone who's using your script can be accommodated including English!

Thx. Ryu
IP: --   

latin1_swedish_ci --> utf8_general_ci
Brijesh
Group: Softaculous Team
Post Group: Super Member
Posts: 3903
Status:
Hi,

We use cPanel API to create the database and cPanel sets the default character set for the database to latin1_swedish_ci

We have added the code to change the character set while installing WordPress and will launch the package by the end of day today.

-----------------------
SitePad Website Builder
Follow us on Twitter
IP: --   

latin1_swedish_ci --> utf8_general_ci
Brijesh
Group: Softaculous Team
Post Group: Super Member
Posts: 3903
Status:
Hi,

We have launched the updated package of WordPress which sets the database character set to utf8_general_ci

Please ask your host to execute the CRON command on your server to get the updated package immediately :
http://www.softaculous.com/docs/Immediate_update

-----------------------
SitePad Website Builder
Follow us on Twitter
IP: --   

latin1_swedish_ci --> utf8_general_ci
lucky_sevenf
Group: Member
Post Group: Newbie
Posts: 4
Status:
Actually I was referring to your Windows and OSX versions. Are these updated as well?

Thx. Ryu
IP: --   

latin1_swedish_ci --> utf8_general_ci
Brijesh
Group: Softaculous Team
Post Group: Super Member
Posts: 3903
Status:
Hi,

Yes those are updated as well. Please refer to the following guide to execute the CRON command in AMPPS :
http://ampps.com/wiki/Category:FAQs#Cron_Command

-----------------------
SitePad Website Builder
Follow us on Twitter
IP: --   

latin1_swedish_ci --> utf8_general_ci
abdulk
Group: Member
Post Group: Newbie
Posts: 3
Status:
Hello, I downloaded AMPPS today and installed it fresh on my MBP running Yosemite and all my MySQL DBs are using the latin1_swedish_ci collation, including a new install of Prestashop using the included Softaculous installation script.

How can I set the default for ALL DBs to use utf8_general_ci collation?

Thanks,
Abdul
IP: --   

latin1_swedish_ci --> utf8_general_ci
Rishi_P
Group: AMPPS Team
Post Group: Elite Member
Posts: 310
Status:
Hi,

Go to localhost/ampps
select phpMyAdmin OR SQlite Manager
select the database then go to Operation tab
Change collation = utf8_general_ci
Thank You
IP: --   

latin1_swedish_ci --> utf8_general_ci
Rishi_P
Group: AMPPS Team
Post Group: Elite Member
Posts: 310
Status:
Hi,

For default collation

Open AMPPS control panel --> My SQL tab --> configuration
Find this line default-character-set=
And set to default-character-set=utf8_general_ci.
:D


IP: --   

latin1_swedish_ci --> utf8_general_ci
ot2sen
Group: Member
Post Group: Newbie
Posts: 4
Status:
Hi,
Today I installed ampps 3.0 fresh install, and was having similar issue of getting collation latin1_swedish_ci when installing joomla 3.4.1 using the Softaculous installer.
Took a few tries and found a solution that works at stack Exchange http://stackoverflow.com/questions/3513773/change-mysql-default-character-set-to-utf-8-in-my-cnf

Open AMPPS control panel --> MySQL tab --> configuration
Adjust so that you have these lines added/corrected:
[client]default-character-set=utf8


[mysql]
default-character-set=utf8



[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
Restarted and next joomla 3.4.1 install via Softaculous did have collation utf8_generic_ci :)
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is June 19, 2018, 10:16 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.258