Welcome Guest. Please Login or Register  


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



Normal Mode | Print  

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: --   


Threads
 lucky_sevenf   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 100427 times)
    |--  Brijesh   Hi, We use...   on May 10, 2014, 7:49 am
    |--  Brijesh   Hi, We have...   on May 10, 2014, 2:08 pm
    |--  lucky_sevenf   Actually I was...   on May 10, 2014, 5:49 pm
    |--  Brijesh   Hi, Yes those...   on May 11, 2014, 8:05 am
    |--  abdulk   Hello, I downloaded...   on November 19, 2014, 4:52 pm
    |--  Rishi_P   Hi, Go to...   on November 20, 2014, 6:27 am
    |--  Rishi_P   Hi, For default...   on November 20, 2014, 8:11 am
    |--  ot2sen   Hi, Today I...   on April 3, 2015, 6:00 pm

« Previous    Next »

Normal Mode | Print  



Users viewing this topic
6 guests, 0 users.


All times are GMT. The time now is April 30, 2025, 11:07 am.

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