What preferred MySQL collation?

Developer
Van United States
Lid sinds feb. 2018

For LiteCart 2.x, what is the preferred MySQL collation type?

I noticed MySQL uses default utf8_swedish_ci, upon LiteCart installation, it gave warning message.

Checking MySQL database default character set... latin1 [Warning]. The database default charset is not 'utf8' and you might experience trouble with foreign characters. Try performing the following MySQL query: "ALTER DATABASE 'database-name' CHARACTER SET utf8 COLLATE utf8_swedish_ci;"

Is it ok to use uft8_swedish_ci and performing the above command ALTER DATABASE or shall the MySQL database set to different collation type prior to LiteCart installation?

Thank you for feedback.
Bob

tim
Founder
Van Sweden
Lid sinds mei 2013
tim

If you use latin1 you may loose character byte data when storing special characters like €. The collation suitable depends on the languages you have. utf8_general_ci will order åä after a and ö after o while utf8_swedish_ci will order åäö after z.

Developer
Van United States
Lid sinds feb. 2018

Thank you for clarification.

tim
Founder
Van Sweden
Lid sinds mei 2013
tim

You can change collation after installation by going to Admin -> Languages -> Storage Encoding.

Dit topic is gesloten wegens langdurige inactiviteit. Erop posten is niet mogelijk.
Deze website maakt geen gebruik van cookies en geen trackingtechnologie van derden . Wij denken dat we het beter kunnen dan anderen en hechten veel waarde aan uw privacy.